/*
 Navicat MySQL Dump SQL

 Source Server         : 101.126.90.44
 Source Server Type    : MySQL
 Source Server Version : 80042 (8.0.42-0ubuntu0.20.04.1)
 Source Host           : 101.126.90.44:3306
 Source Schema         : sxyc

 Target Server Type    : MySQL
 Target Server Version : 80042 (8.0.42-0ubuntu0.20.04.1)
 File Encoding         : 65001

 Date: 27/05/2025 00:54:40
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for qrtz_blob_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_blob_triggers`;
CREATE TABLE `qrtz_blob_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `BLOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of qrtz_blob_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_calendars
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_calendars`;
CREATE TABLE `qrtz_calendars` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `CALENDAR_NAME` varchar(200) NOT NULL,
  `CALENDAR` blob NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of qrtz_calendars
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_cron_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_cron_triggers`;
CREATE TABLE `qrtz_cron_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `CRON_EXPRESSION` varchar(120) NOT NULL,
  `TIME_ZONE_ID` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of qrtz_cron_triggers
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_cron_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`, `CRON_EXPRESSION`, `TIME_ZONE_ID`) VALUES ('RenrenScheduler', 'TASK_1067246875800000076', 'DEFAULT', '0 0/30 * * * ?', 'Asia/Shanghai');
COMMIT;

-- ----------------------------
-- Table structure for qrtz_fired_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_fired_triggers`;
CREATE TABLE `qrtz_fired_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `ENTRY_ID` varchar(95) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `FIRED_TIME` bigint NOT NULL,
  `SCHED_TIME` bigint NOT NULL,
  `PRIORITY` int NOT NULL,
  `STATE` varchar(16) NOT NULL,
  `JOB_NAME` varchar(200) DEFAULT NULL,
  `JOB_GROUP` varchar(200) DEFAULT NULL,
  `IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`),
  KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`),
  KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`),
  KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of qrtz_fired_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_job_details
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_job_details`;
CREATE TABLE `qrtz_job_details` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250) NOT NULL,
  `IS_DURABLE` varchar(1) NOT NULL,
  `IS_NONCONCURRENT` varchar(1) NOT NULL,
  `IS_UPDATE_DATA` varchar(1) NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) NOT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`),
  KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of qrtz_job_details
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`, `DESCRIPTION`, `JOB_CLASS_NAME`, `IS_DURABLE`, `IS_NONCONCURRENT`, `IS_UPDATE_DATA`, `REQUESTS_RECOVERY`, `JOB_DATA`) VALUES ('RenrenScheduler', 'TASK_1067246875800000076', 'DEFAULT', NULL, 'io.yc.modules.job.utils.ScheduleJob', '0', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372002A696F2E79632E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200074C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B4C000A757064617465446174657400104C6A6176612F7574696C2F446174653B4C0007757064617465727400104C6A6176612F6C616E672F4C6F6E673B7872001E696F2E79632E636F6D6D6F6E2E656E746974792E42617365456E74697479DE5C314069C873070200034C000A6372656174654461746571007E000B4C000763726561746F7271007E000C4C0002696471007E000C78707372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000196325C9350787372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700ECF9F6107B456017371007E00110ECF9F6107B4564C740008746573745461736B74000E3020302F3330202A202A202A203F74000672656E72656E740025E69C89E58F82E6B58BE8AF95EFBC8CE5A49AE4B8AAE58F82E695B0E4BDBFE794A86A736F6E737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0012000000007371007E000F770800000196325C9350787371007E00110ECF9F6107B456017800);
COMMIT;

-- ----------------------------
-- Table structure for qrtz_locks
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_locks`;
CREATE TABLE `qrtz_locks` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `LOCK_NAME` varchar(40) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of qrtz_locks
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_locks` (`SCHED_NAME`, `LOCK_NAME`) VALUES ('RenrenScheduler', 'STATE_ACCESS');
INSERT INTO `qrtz_locks` (`SCHED_NAME`, `LOCK_NAME`) VALUES ('RenrenScheduler', 'TRIGGER_ACCESS');
COMMIT;

-- ----------------------------
-- Table structure for qrtz_paused_trigger_grps
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
CREATE TABLE `qrtz_paused_trigger_grps` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of qrtz_paused_trigger_grps
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_scheduler_state
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_scheduler_state`;
CREATE TABLE `qrtz_scheduler_state` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `LAST_CHECKIN_TIME` bigint NOT NULL,
  `CHECKIN_INTERVAL` bigint NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of qrtz_scheduler_state
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_scheduler_state` (`SCHED_NAME`, `INSTANCE_NAME`, `LAST_CHECKIN_TIME`, `CHECKIN_INTERVAL`) VALUES ('RenrenScheduler', 'LiDongdeMacBook-Pro.local1745232471781', 1745236557087, 15000);
COMMIT;

-- ----------------------------
-- Table structure for qrtz_simple_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simple_triggers`;
CREATE TABLE `qrtz_simple_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `REPEAT_COUNT` bigint NOT NULL,
  `REPEAT_INTERVAL` bigint NOT NULL,
  `TIMES_TRIGGERED` bigint NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of qrtz_simple_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_simprop_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
CREATE TABLE `qrtz_simprop_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `STR_PROP_1` varchar(512) DEFAULT NULL,
  `STR_PROP_2` varchar(512) DEFAULT NULL,
  `STR_PROP_3` varchar(512) DEFAULT NULL,
  `INT_PROP_1` int DEFAULT NULL,
  `INT_PROP_2` int DEFAULT NULL,
  `LONG_PROP_1` bigint DEFAULT NULL,
  `LONG_PROP_2` bigint DEFAULT NULL,
  `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
  `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
  `BOOL_PROP_1` varchar(1) DEFAULT NULL,
  `BOOL_PROP_2` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of qrtz_simprop_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_triggers`;
CREATE TABLE `qrtz_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint DEFAULT NULL,
  `PREV_FIRE_TIME` bigint DEFAULT NULL,
  `PRIORITY` int DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) NOT NULL,
  `TRIGGER_TYPE` varchar(8) NOT NULL,
  `START_TIME` bigint NOT NULL,
  `END_TIME` bigint DEFAULT NULL,
  `CALENDAR_NAME` varchar(200) DEFAULT NULL,
  `MISFIRE_INSTR` smallint DEFAULT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`),
  KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of qrtz_triggers
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`, `JOB_NAME`, `JOB_GROUP`, `DESCRIPTION`, `NEXT_FIRE_TIME`, `PREV_FIRE_TIME`, `PRIORITY`, `TRIGGER_STATE`, `TRIGGER_TYPE`, `START_TIME`, `END_TIME`, `CALENDAR_NAME`, `MISFIRE_INSTR`, `JOB_DATA`) VALUES ('RenrenScheduler', 'TASK_1067246875800000076', 'DEFAULT', 'TASK_1067246875800000076', 'DEFAULT', NULL, 1745233200000, -1, 5, 'PAUSED', 'CRON', 1745232474000, 0, NULL, 2, '');
COMMIT;

-- ----------------------------
-- Table structure for schedule_job
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job`;
CREATE TABLE `schedule_job` (
  `id` bigint NOT NULL COMMENT 'id',
  `bean_name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'spring bean名称',
  `params` varchar(2000) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '参数',
  `cron_expression` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'cron表达式',
  `status` tinyint unsigned DEFAULT NULL COMMENT '任务状态  0：暂停  1：正常',
  `remark` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='定时任务';

-- ----------------------------
-- Records of schedule_job
-- ----------------------------
BEGIN;
INSERT INTO `schedule_job` (`id`, `bean_name`, `params`, `cron_expression`, `status`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000076, 'testTask', 'renren', '0 0/30 * * * ?', 0, '有参测试，多个参数使用json', 1067246875800000001, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
COMMIT;

-- ----------------------------
-- Table structure for schedule_job_log
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job_log`;
CREATE TABLE `schedule_job_log` (
  `id` bigint NOT NULL COMMENT 'id',
  `job_id` bigint NOT NULL COMMENT '任务id',
  `bean_name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'spring bean名称',
  `params` varchar(2000) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '参数',
  `status` tinyint unsigned NOT NULL COMMENT '任务状态    0：失败    1：成功',
  `error` varchar(2000) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '失败信息',
  `times` int NOT NULL COMMENT '耗时(单位：毫秒)',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_job_id` (`job_id`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='定时任务日志';

-- ----------------------------
-- Records of schedule_job_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `id` bigint NOT NULL COMMENT 'id',
  `pid` bigint DEFAULT NULL COMMENT '上级ID',
  `pids` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '所有上级ID，用逗号分开',
  `name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '部门名称',
  `sort` int unsigned DEFAULT NULL COMMENT '排序',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_pid` (`pid`),
  KEY `idx_sort` (`sort`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='部门管理';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` (`id`, `pid`, `pids`, `name`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000066, 0, '0', '研诚集团', 0, 1067246875800000001, '2025-04-15 11:09:33', 10000, '2025-05-16 14:21:11');
INSERT INTO `sys_dept` (`id`, `pid`, `pids`, `name`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1926856420882685953, 1067246875800000066, '1067246875800000066', '财务部', 0, 10000, '2025-05-26 12:22:25', 10000, '2025-05-26 12:22:25');
INSERT INTO `sys_dept` (`id`, `pid`, `pids`, `name`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1926856471658930178, 1067246875800000066, '1067246875800000066', '技术部', 0, 10000, '2025-05-26 12:22:37', 10000, '2025-05-26 12:22:37');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_data`;
CREATE TABLE `sys_dict_data` (
  `id` bigint NOT NULL COMMENT 'id',
  `dict_type_id` bigint NOT NULL COMMENT '字典类型ID',
  `dict_label` varchar(255) COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典标签',
  `dict_value` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '字典值',
  `remark` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `sort` int unsigned DEFAULT NULL COMMENT '排序',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_dict_type_value` (`dict_type_id`,`dict_value`),
  KEY `idx_sort` (`sort`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='字典数据';

-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `remark`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1160061112075464705, 1160061077912858625, '男', '0', '', 0, 1067246875800000001, '2025-04-23 01:43:44', 1067246875800000001, '2025-04-23 01:43:44');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `remark`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1160061146967879681, 1160061077912858625, '女', '1', '', 1, 1067246875800000001, '2025-04-23 01:43:44', 1067246875800000001, '2025-04-23 01:43:44');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `remark`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1160061190127267841, 1160061077912858625, '保密', '2', '', 2, 1067246875800000001, '2025-04-23 01:43:44', 1067246875800000001, '2025-04-23 01:43:44');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `remark`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1225814069634195457, 1225813644059140097, '公告', '0', '', 0, 1067246875800000001, '2025-04-23 01:43:44', 1067246875800000001, '2025-04-23 01:43:44');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `remark`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1225814107559092225, 1225813644059140097, '会议', '1', '', 1, 1067246875800000001, '2025-04-23 01:43:44', 1067246875800000001, '2025-04-23 01:43:44');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `remark`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1225814271879340034, 1225813644059140097, '其他', '2', '', 2, 1067246875800000001, '2025-04-23 01:43:44', 1067246875800000001, '2025-04-23 01:43:44');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `dict_type` varchar(100) COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典类型',
  `dict_name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典名称',
  `remark` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `sort` int unsigned DEFAULT NULL COMMENT '排序',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `dict_type` (`dict_type`)
) ENGINE=InnoDB AUTO_INCREMENT=1225813644059140098 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='字典类型';

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_type` (`id`, `dict_type`, `dict_name`, `remark`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1160061077912858625, 'gender', '性别', '', 0, 1067246875800000001, '2025-04-23 01:43:44', 1067246875800000001, '2025-04-23 01:43:44');
INSERT INTO `sys_dict_type` (`id`, `dict_type`, `dict_name`, `remark`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1225813644059140097, 'notice_type', '站内通知-类型', '', 1, 1067246875800000001, '2025-04-23 01:43:44', 1067246875800000001, '2025-04-23 01:43:44');
COMMIT;

-- ----------------------------
-- Table structure for sys_log_error
-- ----------------------------
DROP TABLE IF EXISTS `sys_log_error`;
CREATE TABLE `sys_log_error` (
  `id` bigint NOT NULL COMMENT 'id',
  `request_uri` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '请求URI',
  `request_method` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '请求方式',
  `request_params` text COLLATE utf8mb4_general_ci COMMENT '请求参数',
  `user_agent` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户代理',
  `ip` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作IP',
  `error_info` text COLLATE utf8mb4_general_ci COMMENT '异常信息',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='异常日志';


-- ----------------------------
-- Table structure for sys_log_login
-- ----------------------------
DROP TABLE IF EXISTS `sys_log_login`;
CREATE TABLE `sys_log_login` (
  `id` bigint NOT NULL COMMENT 'id',
  `operation` tinyint unsigned DEFAULT NULL COMMENT '用户操作   0：用户登录   1：用户退出',
  `status` tinyint unsigned NOT NULL COMMENT '状态  0：失败    1：成功    2：账号已锁定',
  `user_agent` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户代理',
  `ip` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作IP',
  `creator_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户名',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_status` (`status`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='登录日志';

-- ----------------------------
-- Table structure for sys_log_operation
-- ----------------------------
DROP TABLE IF EXISTS `sys_log_operation`;
CREATE TABLE `sys_log_operation` (
  `id` bigint NOT NULL COMMENT 'id',
  `operation` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户操作',
  `request_uri` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '请求URI',
  `request_method` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '请求方式',
  `request_params` text COLLATE utf8mb4_general_ci COMMENT '请求参数',
  `request_time` int unsigned NOT NULL COMMENT '请求时长(毫秒)',
  `user_agent` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户代理',
  `ip` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作IP',
  `status` tinyint unsigned NOT NULL COMMENT '状态  0：失败   1：成功',
  `creator_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户名',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='操作日志';

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` bigint NOT NULL COMMENT 'id',
  `pid` bigint DEFAULT NULL COMMENT '上级ID，一级菜单为0',
  `name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
  `url` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单URL',
  `permissions` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：sys:user:list,sys:user:save)',
  `menu_type` tinyint unsigned DEFAULT NULL COMMENT '类型   0：菜单   1：按钮',
  `icon` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单图标',
  `sort` int DEFAULT NULL COMMENT '排序',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_pid` (`pid`),
  KEY `idx_sort` (`sort`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='菜单管理';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000002, 0, '权限管理', NULL, NULL, 0, 'icon-safetycertificate', 100, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000003, 1067246875800000055, '新增', NULL, 'sys:user:save,sys:dept:list,sys:role:list', 1, NULL, 1, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000004, 1067246875800000055, '修改', NULL, 'sys:user:update,sys:dept:list,sys:role:list', 1, NULL, 2, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000005, 1067246875800000055, '删除', NULL, 'sys:user:delete', 1, NULL, 3, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000006, 1067246875800000055, '导出', NULL, 'sys:user:export', 1, NULL, 4, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000007, 1067246875800000002, '角色管理', 'sys/role', NULL, 0, 'icon-team', 2, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000008, 1067246875800000007, '查看', NULL, 'sys:role:page,sys:role:info', 1, NULL, 0, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000009, 1067246875800000007, '新增', NULL, 'sys:role:save,sys:menu:select,sys:dept:list', 1, NULL, 1, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000010, 1067246875800000007, '修改', NULL, 'sys:role:update,sys:menu:select,sys:dept:list', 1, NULL, 2, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000011, 1067246875800000007, '删除', NULL, 'sys:role:delete', 1, NULL, 3, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000012, 1067246875800000002, '部门管理', 'sys/dept', NULL, 0, 'icon-apartment', 1, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000014, 1067246875800000012, '查看', NULL, 'sys:dept:list,sys:dept:info', 1, NULL, 0, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000015, 1067246875800000012, '新增', NULL, 'sys:dept:save', 1, NULL, 1, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000016, 1067246875800000012, '修改', NULL, 'sys:dept:update', 1, NULL, 2, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000017, 1067246875800000012, '删除', NULL, 'sys:dept:delete', 1, NULL, 3, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000025, 1067246875800000035, '菜单管理', 'sys/menu', NULL, 0, 'icon-unorderedlist', 0, 10000, '2025-04-14 11:34:09', 10000, '2025-05-18 00:24:59');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000026, 1067246875800000025, '查看', NULL, 'sys:menu:list,sys:menu:info', 1, NULL, 0, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000027, 1067246875800000025, '新增', NULL, 'sys:menu:save', 1, NULL, 1, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000028, 1067246875800000025, '修改', NULL, 'sys:menu:update', 1, NULL, 2, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000029, 1067246875800000025, '删除', NULL, 'sys:menu:delete', 1, NULL, 3, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000030, 1067246875800000035, '定时任务', 'job/schedule', NULL, 0, 'icon-dashboard', 3, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000031, 1067246875800000030, '查看', NULL, 'sys:schedule:page,sys:schedule:info', 1, NULL, 0, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000032, 1067246875800000030, '新增', NULL, 'sys:schedule:save', 1, NULL, 1, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000033, 1067246875800000030, '修改', NULL, 'sys:schedule:update', 1, NULL, 2, 10000, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000034, 1067246875800000030, '删除', NULL, 'sys:schedule:delete', 1, NULL, 3, 10000, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000035, 0, '系统设置', NULL, NULL, 0, 'icon-setting', 102, 10000, '2025-04-14 11:34:10', 10000, '2025-05-18 00:22:58');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000036, 1067246875800000030, '暂停', NULL, 'sys:schedule:pause', 1, NULL, 4, 10000, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000037, 1067246875800000030, '恢复', NULL, 'sys:schedule:resume', 1, NULL, 5, 10000, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000038, 1067246875800000030, '立即执行', NULL, 'sys:schedule:run', 1, NULL, 6, 10000, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000039, 1067246875800000030, '日志列表', NULL, 'sys:schedule:log', 1, NULL, 7, 10000, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000040, 1067246875800000035, '参数管理', 'sys/params', '', 0, 'icon-fileprotect', 1, 10000, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000041, 1067246875800000035, '字典管理', 'sys/dict-type', NULL, 0, 'icon-golden-fill', 2, 10000, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000042, 1067246875800000041, '查看', NULL, 'sys:dict:page,sys:dict:info', 1, NULL, 0, 10000, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000043, 1067246875800000041, '新增', NULL, 'sys:dict:save', 1, NULL, 1, 10000, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000044, 1067246875800000041, '修改', NULL, 'sys:dict:update', 1, NULL, 2, 10000, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000045, 1067246875800000041, '删除', NULL, 'sys:dict:delete', 1, NULL, 3, 10000, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000046, 0, '日志管理', NULL, NULL, 0, 'icon-container', 101, 10000, '2025-04-14 11:34:10', 10000, '2025-05-18 00:23:02');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000047, 1067246875800000035, '文件上传', 'oss/oss', 'sys:oss:all', 0, 'icon-upload', 4, 10000, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000048, 1067246875800000046, '登录日志', 'sys/log-login', 'sys:log:login', 0, 'icon-filedone', 0, 10000, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000049, 1067246875800000046, '操作日志', 'sys/log-operation', 'sys:log:operation', 0, 'icon-solution', 1, 10000, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000050, 1067246875800000046, '异常日志', 'sys/log-error', 'sys:log:error', 0, 'icon-file-exception', 2, 10000, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000053, 0, '系统接口', NULL, NULL, 0, 'icon-desktop', 103, 10000, '2025-04-14 11:34:10', 10000, '2025-05-18 00:24:31');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000055, 1067246875800000002, '用户管理', 'sys/user', NULL, 0, 'icon-user', 0, 10000, '2025-04-14 11:34:10', 10000, '2025-05-18 00:24:48');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000056, 1067246875800000055, '查看', NULL, 'sys:user:page,sys:user:info', 1, NULL, 0, 10000, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000057, 1067246875800000040, '新增', NULL, 'sys:params:save', 1, NULL, 1, 10000, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000058, 1067246875800000040, '导出', NULL, 'sys:params:export', 1, NULL, 4, 10000, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000059, 1067246875800000040, '查看', '', 'sys:params:page,sys:params:info', 1, NULL, 0, 10000, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000060, 1067246875800000040, '修改', NULL, 'sys:params:update', 1, NULL, 2, 10000, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000061, 1067246875800000040, '删除', '', 'sys:params:delete', 1, '', 3, 10000, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1156748733921165314, 1067246875800000053, '接口文档', '{{ApiUrl}}/doc.html', '', 0, 'icon-file-word', 1, 10000, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832010400624641, 1911971227599589378, '开票记录', 'yckj/invoicelogs', NULL, 0, 'icon-desktop', 2, 10000, '2025-04-15 01:33:06', 10000, '2025-04-27 14:36:04');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832010400624642, 1911832010400624641, '查看', NULL, 'yckj:invoicelogs:page,yckj:invoicelogs:info', 1, NULL, 0, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832010400624643, 1911832010400624641, '新增', NULL, 'yckj:invoicelogs:save', 1, NULL, 1, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832010400624644, 1911832010400624641, '修改', NULL, 'yckj:invoicelogs:update', 1, NULL, 2, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832010400624645, 1911832010400624641, '删除', NULL, 'yckj:invoicelogs:delete', 1, NULL, 3, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832010400624646, 1911832010400624641, '导出', NULL, 'yckj:invoicelogs:export', 1, NULL, 4, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832010706808834, 1912704835897417730, '优惠券日志', 'yckj/couponslogs', NULL, 0, 'icon-desktop', 0, 10000, '2025-04-15 01:33:06', 10000, '2025-04-22 15:11:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832010706808835, 1911832010706808834, '查看', NULL, 'yckj:couponslogs:page,yckj:couponslogs:info', 1, NULL, 0, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832010706808836, 1911832010706808834, '新增', NULL, 'yckj:couponslogs:save', 1, NULL, 1, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832010706808837, 1911832010706808834, '修改', NULL, 'yckj:couponslogs:update', 1, NULL, 2, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832010706808838, 1911832010706808834, '删除', NULL, 'yckj:couponslogs:delete', 1, NULL, 3, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832010706808839, 1911832010706808834, '导出', NULL, 'yckj:couponslogs:export', 1, NULL, 4, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832010866192386, 1911970729580515330, '用户列表', 'yckj/user', NULL, 0, 'icon-user', 0, 10000, '2025-04-15 01:33:06', 10000, '2025-04-22 23:59:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832010866192387, 1911832010866192386, '查看', NULL, 'yckj:user:page,yckj:user:info', 1, NULL, 0, 10000, '2025-04-15 01:33:07', 1067246875800000001, '2025-04-15 01:33:07');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832010866192388, 1911832010866192386, '新增', NULL, 'yckj:user:save', 1, NULL, 1, 10000, '2025-04-15 01:33:07', 1067246875800000001, '2025-04-15 01:33:07');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832010866192389, 1911832010866192386, '修改', NULL, 'yckj:user:update', 1, NULL, 2, 10000, '2025-04-15 01:33:07', 1067246875800000001, '2025-04-15 01:33:07');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832010866192390, 1911832010866192386, '删除', NULL, 'yckj:user:delete', 1, NULL, 3, 10000, '2025-04-15 01:33:07', 1067246875800000001, '2025-04-15 01:33:07');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832010866192391, 1911832010866192386, '导出', NULL, 'yckj:user:export', 1, NULL, 4, 10000, '2025-04-15 01:33:07', 1067246875800000001, '2025-04-15 01:33:07');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832011382091777, 1911972119769993217, '项目列表', 'yckj/project', NULL, 0, 'icon-detail', 1, 10000, '2025-04-15 01:33:06', 10000, '2025-04-25 00:18:59');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832011382091778, 1911832011382091777, '查看', NULL, 'yckj:project:page,yckj:project:info', 1, NULL, 0, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832011382091779, 1911832011382091777, '新增', NULL, 'yckj:project:save', 1, NULL, 1, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832011382091780, 1911832011382091777, '修改', NULL, 'yckj:project:update', 1, NULL, 2, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832011382091781, 1911832011382091777, '删除', NULL, 'yckj:project:delete', 1, NULL, 3, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832011382091782, 1911832011382091777, '导出', NULL, 'yckj:project:export', 1, NULL, 4, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832011826688002, 1911971707906117634, '分类列表', 'yckj/cate', NULL, 0, 'icon-unorderedlist', 0, 10000, '2025-04-15 01:33:06', 10000, '2025-05-09 13:39:16');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832011826688003, 1911832011826688002, '查看', NULL, 'yckj:cate:list,yckj:cate:info', 1, NULL, 0, 10000, '2025-04-15 01:33:06', 10000, '2025-04-22 11:16:22');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832011826688004, 1911832011826688002, '新增', NULL, 'yckj:cate:save', 1, NULL, 1, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832011826688005, 1911832011826688002, '修改', NULL, 'yckj:cate:update', 1, NULL, 2, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832011826688006, 1911832011826688002, '删除', NULL, 'yckj:cate:delete', 1, NULL, 3, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832011826688007, 1911832011826688002, '导出', NULL, 'yckj:cate:export', 1, NULL, 4, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832011994460162, 1911971227599589378, '订单列表', 'yckj/order', NULL, 0, 'icon-desktop', 0, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 11:02:53');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832011994460163, 1911832011994460162, '查看', NULL, 'yckj:order:page,yckj:order:info', 1, NULL, 0, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832011994460164, 1911832011994460162, '新增', NULL, 'yckj:order:save', 1, NULL, 1, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832011994460165, 1911832011994460162, '修改', NULL, 'yckj:order:update', 1, NULL, 2, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832011994460166, 1911832011994460162, '删除', NULL, 'yckj:order:delete', 1, NULL, 3, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832011994460167, 1911832011994460162, '导出', NULL, 'yckj:order:export', 1, NULL, 4, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012158038017, 1911970729580515330, '资产记录', 'yckj/assetlog', NULL, 0, 'icon-moneycollect', 1, 10000, '2025-04-15 01:33:06', 10000, '2025-04-23 00:00:13');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012158038018, 1911832012158038017, '查看', NULL, 'yckj:assetlog:page,yckj:assetlog:info', 1, NULL, 0, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012158038019, 1911832012158038017, '新增', NULL, 'yckj:assetlog:save', 1, NULL, 1, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012158038020, 1911832012158038017, '修改', NULL, 'yckj:assetlog:update', 1, NULL, 2, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012158038021, 1911832012158038017, '删除', NULL, 'yckj:assetlog:delete', 1, NULL, 3, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012158038022, 1911832012158038017, '导出', NULL, 'yckj:assetlog:export', 1, NULL, 4, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012317421569, 1912704835897417730, '优惠券列表', 'yckj/coupons', NULL, 0, 'icon-tags', 0, 10000, '2025-04-15 01:33:06', 10000, '2025-04-22 15:52:40');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012317421570, 1911832012317421569, '查看', NULL, 'yckj:coupons:page,yckj:coupons:info', 1, NULL, 0, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012317421571, 1911832012317421569, '新增', NULL, 'yckj:coupons:save', 1, NULL, 1, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012317421572, 1911832012317421569, '修改', NULL, 'yckj:coupons:update', 1, NULL, 2, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012317421573, 1911832012317421569, '删除', NULL, 'yckj:coupons:delete', 1, NULL, 3, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012317421574, 1911832012317421569, '导出', NULL, 'yckj:coupons:export', 1, NULL, 4, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012472610817, 1911970729580515330, '地址列表', 'yckj/address', NULL, 0, 'icon-location', 3, 10000, '2025-04-15 01:33:05', 10000, '2025-04-26 00:15:37');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012472610818, 1911832012472610817, '查看', NULL, 'yckj:address:page,yckj:address:info', 1, NULL, 0, 10000, '2025-04-15 01:33:05', 1067246875800000001, '2025-04-15 01:33:05');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012472610819, 1911832012472610817, '新增', NULL, 'yckj:address:save', 1, NULL, 1, 10000, '2025-04-15 01:33:05', 1067246875800000001, '2025-04-15 01:33:05');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012472610820, 1911832012472610817, '修改', NULL, 'yckj:address:update', 1, NULL, 2, 10000, '2025-04-15 01:33:05', 1067246875800000001, '2025-04-15 01:33:05');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012472610821, 1911832012472610817, '删除', NULL, 'yckj:address:delete', 1, NULL, 3, 10000, '2025-04-15 01:33:05', 1067246875800000001, '2025-04-15 01:33:05');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012472610822, 1911832012472610817, '导出', NULL, 'yckj:address:export', 1, NULL, 4, 10000, '2025-04-15 01:33:05', 1067246875800000001, '2025-04-15 01:33:05');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012623605761, 1911970729580515330, '发票抬头', 'yckj/invoice', NULL, 0, 'icon-desktop', 4, 10000, '2025-04-15 01:33:06', 10000, '2025-04-27 14:35:37');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012623605762, 1911832012623605761, '查看', NULL, 'yckj:invoice:page,yckj:invoice:info', 1, NULL, 0, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012623605763, 1911832012623605761, '新增', NULL, 'yckj:invoice:save', 1, NULL, 1, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012623605764, 1911832012623605761, '修改', NULL, 'yckj:invoice:update', 1, NULL, 2, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012623605765, 1911832012623605761, '删除', NULL, 'yckj:invoice:delete', 1, NULL, 3, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012623605766, 1911832012623605761, '导出', NULL, 'yckj:invoice:export', 1, NULL, 4, 10000, '2025-04-15 01:33:06', 1067246875800000001, '2025-04-15 01:33:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012774600706, 1911971707906117634, '轮播图列表', 'yckj/ads', NULL, 0, 'icon-image', 1, 10000, '2025-04-15 01:33:05', 10000, '2025-05-09 13:39:48');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012774600707, 1911832012774600706, '查看', NULL, 'yckj:ads:page,yckj:ads:info', 1, NULL, 0, 10000, '2025-04-15 01:33:05', 1067246875800000001, '2025-04-15 01:33:05');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012774600708, 1911832012774600706, '新增', NULL, 'yckj:ads:save', 1, NULL, 1, 10000, '2025-04-15 01:33:05', 1067246875800000001, '2025-04-15 01:33:05');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012774600709, 1911832012774600706, '修改', NULL, 'yckj:ads:update', 1, NULL, 2, 10000, '2025-04-15 01:33:05', 1067246875800000001, '2025-04-15 01:33:05');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012774600710, 1911832012774600706, '删除', NULL, 'yckj:ads:delete', 1, NULL, 3, 10000, '2025-04-15 01:33:05', 1067246875800000001, '2025-04-15 01:33:05');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911832012774600711, 1911832012774600706, '导出', NULL, 'yckj:ads:export', 1, NULL, 4, 10000, '2025-04-15 01:33:05', 1067246875800000001, '2025-04-15 01:33:05');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911970729580515330, 0, '用户管理', '', '', 0, 'icon-team', 4, 10000, '2025-04-15 10:31:59', 1067246875800000001, '2025-04-15 10:31:59');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911971227599589378, 0, '订单管理', '', '', 0, 'icon-accountbook', 6, 10000, '2025-04-15 10:33:58', 10000, '2025-04-27 14:33:03');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911971707906117634, 0, '主页管理', '', '', 0, 'icon-sound', 2, 10000, '2025-04-15 10:35:53', 10000, '2025-05-09 13:39:35');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1911972119769993217, 0, '项目管理', '', '', 0, 'icon-database', 3, 10000, '2025-04-15 10:37:31', 1067246875800000001, '2025-04-15 10:37:31');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1912413771678691329, 1911972119769993217, '机器列表', 'yckj/machine', NULL, 0, 'icon-sever', 0, 10000, '2025-04-16 15:56:13', 10000, '2025-04-23 00:01:46');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1912413771678691330, 1912413771678691329, '查看', NULL, 'yckj:machine:page,yckj:machine:info', 1, NULL, 0, 10000, '2025-04-16 15:56:13', 1067246875800000001, '2025-04-16 15:56:13');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1912413771678691331, 1912413771678691329, '新增', NULL, 'yckj:machine:save', 1, NULL, 1, 10000, '2025-04-16 15:56:13', 1067246875800000001, '2025-04-16 15:56:13');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1912413771678691332, 1912413771678691329, '修改', NULL, 'yckj:machine:update', 1, NULL, 2, 10000, '2025-04-16 15:56:13', 1067246875800000001, '2025-04-16 15:56:13');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1912413771678691333, 1912413771678691329, '删除', NULL, 'yckj:machine:delete', 1, NULL, 3, 10000, '2025-04-16 15:56:13', 1067246875800000001, '2025-04-16 15:56:13');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1912413771678691334, 1912413771678691329, '导出', NULL, 'yckj:machine:export', 1, NULL, 4, 10000, '2025-04-16 15:56:13', 1067246875800000001, '2025-04-16 15:56:13');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1912704835897417730, 0, '卡券管理', '', '', 0, 'icon-gift', 7, 10000, '2025-04-17 11:09:04', 10000, '2025-04-22 15:15:33');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1912842529695436801, 1912847749926211585, '课题组列表', 'yckj/team', NULL, 0, 'icon-addteam', 0, 1067246875800000001, '2025-04-17 20:21:00', 10000, '2025-04-22 19:59:08');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1912842529695436802, 1912842529695436801, '查看', NULL, 'yckj:team:page,yckj:team:info', 1, NULL, 0, 1067246875800000001, '2025-04-17 20:21:00', 1067246875800000001, '2025-04-17 20:21:00');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1912842529695436803, 1912842529695436801, '新增', NULL, 'yckj:team:save', 1, NULL, 1, 1067246875800000001, '2025-04-17 20:21:00', 1067246875800000001, '2025-04-17 20:21:00');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1912842529695436804, 1912842529695436801, '修改', NULL, 'yckj:team:update', 1, NULL, 2, 1067246875800000001, '2025-04-17 20:21:00', 1067246875800000001, '2025-04-17 20:21:00');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1912842529695436805, 1912842529695436801, '删除', NULL, 'yckj:team:delete', 1, NULL, 3, 1067246875800000001, '2025-04-17 20:21:00', 1067246875800000001, '2025-04-17 20:21:00');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1912842529695436806, 1912842529695436801, '导出', NULL, 'yckj:team:export', 1, NULL, 4, 1067246875800000001, '2025-04-17 20:21:00', 1067246875800000001, '2025-04-17 20:21:00');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1912847749926211585, 0, '课题组管理', '', '', 0, 'icon-addteam', 5, 10000, '2025-04-17 20:36:57', 10000, '2025-05-13 20:56:46');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1914549137965658114, 1911971707906117634, '活动列表', 'yckj/activity', NULL, 0, 'icon-notification', 2, 1067246875800000001, '2025-04-22 13:25:41', 10000, '2025-05-09 13:39:53');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1914549137965658115, 1914549137965658114, '查看', NULL, 'yckj:activity:page,yckj:activity:info', 1, NULL, 0, 1067246875800000001, '2025-04-22 13:25:41', 1067246875800000001, '2025-04-22 13:25:41');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1914549137965658116, 1914549137965658114, '新增', NULL, 'yckj:activity:save', 1, NULL, 1, 1067246875800000001, '2025-04-22 13:25:41', 1067246875800000001, '2025-04-22 13:25:41');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1914549137965658117, 1914549137965658114, '修改', NULL, 'yckj:activity:update', 1, NULL, 2, 1067246875800000001, '2025-04-22 13:25:41', 1067246875800000001, '2025-04-22 13:25:41');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1914549137965658118, 1914549137965658114, '删除', NULL, 'yckj:activity:delete', 1, NULL, 3, 1067246875800000001, '2025-04-22 13:25:41', 1067246875800000001, '2025-04-22 13:25:41');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1914549137965658119, 1914549137965658114, '导出', NULL, 'yckj:activity:export', 1, NULL, 4, 1067246875800000001, '2025-04-22 13:25:41', 1067246875800000001, '2025-04-22 13:25:41');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1917200577025773569, 1911832011994460162, '确认金额', '', 'yckj:order:amount', 1, '', 10, 10000, '2025-04-29 20:53:32', 10000, '2025-04-29 20:53:41');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1917200889056825346, 1911832011994460162, '确认技术员', NULL, 'yckj:order:tech', 1, NULL, 11, 10000, '2025-04-29 20:54:46', 10000, '2025-04-29 20:54:46');
COMMIT;

-- ----------------------------
-- Table structure for sys_oss
-- ----------------------------
DROP TABLE IF EXISTS `sys_oss`;
CREATE TABLE `sys_oss` (
  `id` bigint NOT NULL COMMENT 'id',
  `url` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'URL地址',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='文件上传';

-- ----------------------------
-- Records of sys_oss
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_params
-- ----------------------------
DROP TABLE IF EXISTS `sys_params`;
CREATE TABLE `sys_params` (
  `id` bigint NOT NULL COMMENT 'id',
  `param_code` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '参数编码',
  `param_value` varchar(2000) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '参数值',
  `param_type` tinyint unsigned DEFAULT '1' COMMENT '类型   0：系统参数   1：非系统参数',
  `remark` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_param_code` (`param_code`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='参数管理';

-- ----------------------------
-- Records of sys_params
-- ----------------------------
BEGIN;
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000073, 'CLOUD_STORAGE_CONFIG_KEY', '{\"type\":1,\"qiniuDomain\":\"http://test.oss.renren.io\",\"qiniuPrefix\":\"upload\",\"qiniuAccessKey\":\"NrgMfABZxWLo5B-YYSjoE8-AZ1EISdi1Z3ubLOeZ\",\"qiniuSecretKey\":\"uIwJHevMRWU0VLxFvgy0tAcOdGqasdtVlJkdy6vV\",\"qiniuBucketName\":\"renren-oss\",\"aliyunDomain\":\"\",\"aliyunPrefix\":\"\",\"aliyunEndPoint\":\"\",\"aliyunAccessKeyId\":\"\",\"aliyunAccessKeySecret\":\"\",\"aliyunBucketName\":\"\",\"qcloudDomain\":\"\",\"qcloudPrefix\":\"\",\"qcloudSecretId\":\"\",\"qcloudSecretKey\":\"\",\"qcloudBucketName\":\"\"}', 0, '云存储配置信息', 1067246875800000001, '2025-04-14 11:34:10', 1067246875800000001, '2025-04-14 11:34:10');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` bigint NOT NULL COMMENT 'id',
  `name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '角色名称',
  `remark` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT NULL COMMENT '部门ID',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_dept_id` (`dept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='角色管理';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`id`, `name`, `remark`, `dept_id`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1915085865837719553, '项目管理员', 'projecter', NULL, 10000, '2025-04-24 00:50:26', 10000, '2025-04-24 00:50:44');
INSERT INTO `sys_role` (`id`, `name`, `remark`, `dept_id`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1925812372931629057, '订单管理员', '微信公众号用户', NULL, 10000, '2025-05-23 15:13:44', 10000, '2025-05-23 15:14:37');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_data_scope
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_data_scope`;
CREATE TABLE `sys_role_data_scope` (
  `id` bigint NOT NULL COMMENT 'id',
  `role_id` bigint DEFAULT NULL COMMENT '角色ID',
  `dept_id` bigint DEFAULT NULL COMMENT '部门ID',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_role_id` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='角色数据权限';

-- ----------------------------
-- Records of sys_role_data_scope
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` bigint NOT NULL COMMENT 'id',
  `role_id` bigint DEFAULT NULL COMMENT '角色ID',
  `menu_id` bigint DEFAULT NULL COMMENT '菜单ID',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_role_id` (`role_id`),
  KEY `idx_menu_id` (`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='角色菜单关系';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085944699023362, 1915085865837719553, 1911972119769993217, 10000, '2025-04-24 00:50:44');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085944803880962, 1915085865837719553, 1912413771678691329, 10000, '2025-04-24 00:50:44');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085944917127170, 1915085865837719553, 1912413771678691330, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085945030373378, 1915085865837719553, 1912413771678691331, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085945139425282, 1915085865837719553, 1912413771678691332, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085945244282882, 1915085865837719553, 1912413771678691333, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085945349140481, 1915085865837719553, 1912413771678691334, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085945458192385, 1915085865837719553, 1911832011382091777, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085945604993025, 1915085865837719553, 1911832011382091778, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085945718239234, 1915085865837719553, 1911832011382091779, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085945827291137, 1915085865837719553, 1911832011382091780, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085946292858881, 1915085865837719553, 1911832011382091781, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085946401910785, 1915085865837719553, 1911832011382091782, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085946506768386, 1915085865837719553, 1911832011679887362, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085946620014594, 1915085865837719553, 1911832011679887363, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085946724872193, 1915085865837719553, 1911832011679887364, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085946859089921, 1915085865837719553, 1911832011679887365, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085946968141825, 1915085865837719553, 1911832011679887366, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085947072999425, 1915085865837719553, 1911832011679887367, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085947177857025, 1915085865837719553, 1911832011533086722, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085947291103234, 1915085865837719553, 1911832011533086723, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085947517595649, 1915085865837719553, 1911832011533086724, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085947978969090, 1915085865837719553, 1911832011533086725, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085948452925442, 1915085865837719553, 1911832011533086726, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1915085948561977346, 1915085865837719553, 1911832011533086727, 10000, '2025-04-24 00:50:45');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1925812594734813185, 1925812372931629057, 1911971227599589378, 10000, '2025-05-23 15:14:37');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1925812594739007490, 1925812372931629057, 1911832011994460162, 10000, '2025-05-23 15:14:37');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1925812594743201793, 1925812372931629057, 1911832011994460163, 10000, '2025-05-23 15:14:37');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1925812594747396097, 1925812372931629057, 1911832011994460164, 10000, '2025-05-23 15:14:37');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1925812594751590401, 1925812372931629057, 1911832011994460165, 10000, '2025-05-23 15:14:37');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1925812594755784705, 1925812372931629057, 1911832011994460166, 10000, '2025-05-23 15:14:37');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1925812594759979010, 1925812372931629057, 1911832011994460167, 10000, '2025-05-23 15:14:37');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1925812594764173313, 1925812372931629057, 1917200577025773569, 10000, '2025-05-23 15:14:37');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1925812594768367618, 1925812372931629057, 1917200889056825346, 10000, '2025-05-23 15:14:37');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1925812594772561922, 1925812372931629057, 1911832010400624641, 10000, '2025-05-23 15:14:37');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1925812594776756225, 1925812372931629057, 1911832010400624642, 10000, '2025-05-23 15:14:37');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1925812594780950529, 1925812372931629057, 1911832010400624643, 10000, '2025-05-23 15:14:37');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1925812594785144834, 1925812372931629057, 1911832010400624644, 10000, '2025-05-23 15:14:37');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1925812594789339137, 1925812372931629057, 1911832010400624645, 10000, '2025-05-23 15:14:37');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_date`) VALUES (1925812594793533441, 1925812372931629057, 1911832010400624646, 10000, '2025-05-23 15:14:37');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_user`;
CREATE TABLE `sys_role_user` (
  `id` bigint NOT NULL COMMENT 'id',
  `role_id` bigint DEFAULT NULL COMMENT '角色ID',
  `user_id` bigint DEFAULT NULL COMMENT '用户ID',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_role_id` (`role_id`),
  KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='角色用户关系';

-- ----------------------------
-- Records of sys_role_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_user` (`id`, `role_id`, `user_id`, `creator`, `create_date`) VALUES (1926117326036791297, 1925812372931629057, 1925814476408639490, 10000, '2025-05-24 11:25:31');
INSERT INTO `sys_role_user` (`id`, `role_id`, `user_id`, `creator`, `create_date`) VALUES (1926117369925988353, 1925812372931629057, 1925810359229501441, 10000, '2025-05-24 11:25:41');
INSERT INTO `sys_role_user` (`id`, `role_id`, `user_id`, `creator`, `create_date`) VALUES (1926117414876344322, 1915085865837719553, 1915085051610066945, 10000, '2025-05-24 11:25:52');
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` bigint NOT NULL COMMENT 'id',
  `username` varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名',
  `mobile` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '手机号',
  `password` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '密码',
  `real_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '姓名',
  `head_url` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '头像',
  `gender` tinyint unsigned DEFAULT NULL COMMENT '性别   0：男   1：女    2：保密',
  `email` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '邮箱',
  `dept_id` bigint DEFAULT NULL COMMENT '部门ID',
  `super_admin` tinyint unsigned DEFAULT NULL COMMENT '超级管理员   0：否   1：是',
  `status` tinyint DEFAULT NULL COMMENT '状态  0：停用   1：正常',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_username` (`username`),
  UNIQUE KEY `uk_mobile` (`mobile`) USING BTREE,
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='系统用户';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`id`, `username`, `mobile`, `password`, `real_name`, `head_url`, `gender`, `email`, `dept_id`, `super_admin`, `status`, `creator`, `create_date`, `updater`, `update_date`) VALUES (10000, 'admin', '13612345678', '$2a$10$012Kx2ba5jzqr9gLlG4MX.bnQJTD9UWqF57XDo2N3.fPtLne02u/m', '管理员', NULL, 0, 'root@renren.io', NULL, 1, 1, 1067246875800000001, '2025-04-14 11:34:09', 1067246875800000001, '2025-04-14 11:34:09');
INSERT INTO `sys_user` (`id`, `username`, `mobile`, `password`, `real_name`, `head_url`, `gender`, `email`, `dept_id`, `super_admin`, `status`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1926865058523291649, 'zhoujun', '18216375570', '$2a$10$lsVolk3Gk7q09wt8tBW.tuo2VmtwOCSRKxm/PVJyOnkD.SN4aPns.', '周俊', NULL, 0, '', 1926856471658930178, 0, 1, 10000, '2025-05-26 12:56:44', 10000, '2025-05-26 12:56:44');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_token
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_token`;
CREATE TABLE `sys_user_token` (
  `id` bigint NOT NULL COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `token` varchar(100) COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户token',
  `expire_date` datetime DEFAULT NULL COMMENT '过期时间',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`),
  UNIQUE KEY `token` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='系统用户Token';

-- ----------------------------
-- Records of sys_user_token
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_token` (`id`, `user_id`, `token`, `expire_date`, `update_date`, `create_date`) VALUES (1911686826978385922, 1067246875800000001, '1e59a09eb843d445c974c211f3cf9dc6', '2025-04-17 23:06:40', '2025-04-17 11:06:40', '2025-04-14 15:43:52');
INSERT INTO `sys_user_token` (`id`, `user_id`, `token`, `expire_date`, `update_date`, `create_date`) VALUES (1912709824766185474, 10000, 'a96d5df4dd2640aa5306d24d40e5991b', '2025-05-27 12:46:32', '2025-05-27 00:46:32', '2025-04-17 11:28:53');
INSERT INTO `sys_user_token` (`id`, `user_id`, `token`, `expire_date`, `update_date`, `create_date`) VALUES (1925823183508762625, 1925810359229501441, '9977a51d930e805ca634cbcb1d3f523e', '2025-05-24 03:56:42', '2025-05-23 15:56:42', '2025-05-23 15:56:42');
INSERT INTO `sys_user_token` (`id`, `user_id`, `token`, `expire_date`, `update_date`, `create_date`) VALUES (1926865178492968961, 1926865058523291649, '900c1a90e36b0202771c77022124e49e', '2025-05-27 00:57:13', '2025-05-26 12:57:13', '2025-05-26 12:57:13');
COMMIT;

-- ----------------------------
-- Table structure for tb_activity
-- ----------------------------
DROP TABLE IF EXISTS `tb_activity`;
CREATE TABLE `tb_activity` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标题',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '内容',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '链接',
  `sort` int DEFAULT NULL COMMENT '排序',
  `status` int DEFAULT '0' COMMENT '是否上架：0否，1是',
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图片',
  `start_time` datetime DEFAULT NULL COMMENT '开始时间',
  `end_time` datetime DEFAULT NULL COMMENT '结束时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10003 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='活动表';

-- ----------------------------
-- Records of tb_activity
-- ----------------------------
BEGIN;
INSERT INTO `tb_activity` (`id`, `title`, `content`, `url`, `sort`, `status`, `image`, `start_time`, `end_time`, `create_time`, `update_time`) VALUES (10000, '活动测试1', '<p>fsdfddsfs</p><p>dsfdfsd&nbsp;<img src=\"http://localhost:8001/public/file/editor/68e7ea88ba0641ca999b06cf47ac1be6.png\" alt=\"\" data-href=\"\" style=\"\"/></p>', NULL, 0, 1, 'http://localhost:8001/public/file/ads/4ff817a0845e4174b556c854639148d3.png', '2025-04-23 00:00:00', '2025-04-30 07:00:00', '2025-05-12 10:11:27', '2025-05-09 18:34:44');
INSERT INTO `tb_activity` (`id`, `title`, `content`, `url`, `sort`, `status`, `image`, `start_time`, `end_time`, `create_time`, `update_time`) VALUES (10001, '测试', '', '', 1, 0, 'http://localhost:8001/public/file/activity/a9dd016da63e4e73b77b34d656c718c6.png', '2025-04-22 00:00:00', '2025-04-30 00:00:00', '2025-05-12 10:11:27', '2025-05-12 10:11:27');
INSERT INTO `tb_activity` (`id`, `title`, `content`, `url`, `sort`, `status`, `image`, `start_time`, `end_time`, `create_time`, `update_time`) VALUES (10002, '充值大礼包', '<p>现在来充值，好礼大放送！</p>', '', 1, 1, 'http://101.126.90.44/file/activity/043467efe0d047688f2bb87d335b3eb2.jpg', NULL, NULL, '2025-05-12 10:11:27', '2025-05-12 10:11:27');
COMMIT;

-- ----------------------------
-- Table structure for tb_address
-- ----------------------------
DROP TABLE IF EXISTS `tb_address`;
CREATE TABLE `tb_address` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint DEFAULT NULL COMMENT '用户id',
  `username` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户名称',
  `recipient` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '收件人',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '电话',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '详细地址',
  `is_default` int DEFAULT '0' COMMENT '是否默认，0否，1是',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='地址管理';

-- ----------------------------
-- Records of tb_address
-- ----------------------------
BEGIN;
INSERT INTO `tb_address` (`id`, `user_id`, `username`, `recipient`, `phone`, `address`, `is_default`, `create_time`, `update_time`) VALUES (11, 100003, 'Solo', '孙成龙', '18744008868', '陕西省西安市雁塔区', 1, '2025-05-26 11:38:03', '2025-05-26 11:38:03');
INSERT INTO `tb_address` (`id`, `user_id`, `username`, `recipient`, `phone`, `address`, `is_default`, `create_time`, `update_time`) VALUES (12, 100001, '于俊龙', '于俊龙', '18939559563', '河南省漯河市源汇区', 0, '2025-05-26 17:24:32', '2025-05-26 17:24:32');
COMMIT;

-- ----------------------------
-- Table structure for tb_ads
-- ----------------------------
DROP TABLE IF EXISTS `tb_ads`;
CREATE TABLE `tb_ads` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标题',
  `content` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '内容',
  `url` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '链接',
  `sort` int DEFAULT NULL COMMENT '排序',
  `status` int DEFAULT '0' COMMENT '是否上架：0否，1是',
  `hot` int DEFAULT '0' COMMENT '是否热门：0否，1是',
  `image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图片',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='广告表';

-- ----------------------------
-- Records of tb_ads
-- ----------------------------
BEGIN;
INSERT INTO `tb_ads` (`id`, `title`, `content`, `url`, `sort`, `status`, `hot`, `image`, `create_time`, `update_time`) VALUES (1, '电镜', NULL, NULL, 1, 1, 0, 'http://101.126.90.44/file/ads/55f6cbca3fd0408baddf295403e26912.webp', NULL, '2025-05-16 14:14:55');
INSERT INTO `tb_ads` (`id`, `title`, `content`, `url`, `sort`, `status`, `hot`, `image`, `create_time`, `update_time`) VALUES (2, '电镜2', NULL, NULL, 2, 1, 0, 'http://101.126.90.44/file/ads/709f8573038c4b43b13639f15863170b.webp', '2025-05-09 10:49:04', '2025-05-16 14:15:05');
INSERT INTO `tb_ads` (`id`, `title`, `content`, `url`, `sort`, `status`, `hot`, `image`, `create_time`, `update_time`) VALUES (3, '办公环境', NULL, NULL, 3, 1, 0, 'http://101.126.90.44/file/ads/e7a817f74b244acc96c5a55e5ec8dcbb.webp', '2025-05-09 10:50:04', '2025-05-16 14:15:13');
COMMIT;

-- ----------------------------
-- Table structure for tb_asset_log
-- ----------------------------
DROP TABLE IF EXISTS `tb_asset_log`;
CREATE TABLE `tb_asset_log` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint DEFAULT NULL COMMENT '用户id',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户名称',
  `type` int DEFAULT '0' COMMENT '支出类型: 0收入，1支出',
  `business_type` int DEFAULT '0' COMMENT '充值类型0:个人，1组，3订单',
  `business_id` bigint DEFAULT NULL COMMENT '业务id',
  `amount` decimal(10,2) DEFAULT NULL COMMENT '金额',
  `note` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '说明',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100030 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户资产记录';

-- ----------------------------
-- Records of tb_asset_log
-- ----------------------------
BEGIN;
INSERT INTO `tb_asset_log` (`id`, `user_id`, `username`, `type`, `business_type`, `business_id`, `amount`, `note`, `create_time`, `update_time`) VALUES (100019, 100000, '李东', 0, 1, 200000, 0.05, '河南检测组，第一笔充值', '2025-05-21 20:27:01', '2025-05-21 20:27:01');
INSERT INTO `tb_asset_log` (`id`, `user_id`, `username`, `type`, `business_type`, `business_id`, `amount`, `note`, `create_time`, `update_time`) VALUES (100021, 100000, '李东', 0, 0, NULL, 0.06, '个人充值', '2025-05-21 22:40:50', '2025-05-21 22:40:50');
INSERT INTO `tb_asset_log` (`id`, `user_id`, `username`, `type`, `business_type`, `business_id`, `amount`, `note`, `create_time`, `update_time`) VALUES (100023, 100001, '于俊龙', 0, 0, NULL, 0.02, '快点', '2025-05-21 23:23:48', '2025-05-21 23:23:48');
INSERT INTO `tb_asset_log` (`id`, `user_id`, `username`, `type`, `business_type`, `business_id`, `amount`, `note`, `create_time`, `update_time`) VALUES (100024, 100000, '李东', 1, 2, NULL, 0.01, '订单支付', '2025-05-22 00:11:36', '2025-05-22 00:11:36');
INSERT INTO `tb_asset_log` (`id`, `user_id`, `username`, `type`, `business_type`, `business_id`, `amount`, `note`, `create_time`, `update_time`) VALUES (100025, 100000, '李东', 1, 2, 600007, 0.01, NULL, '2025-05-22 00:24:13', '2025-05-22 00:24:13');
INSERT INTO `tb_asset_log` (`id`, `user_id`, `username`, `type`, `business_type`, `business_id`, `amount`, `note`, `create_time`, `update_time`) VALUES (100026, 100000, '李东', 1, 2, NULL, 0.01, '订单支付', '2025-05-22 15:44:09', '2025-05-22 15:44:09');
INSERT INTO `tb_asset_log` (`id`, `user_id`, `username`, `type`, `business_type`, `business_id`, `amount`, `note`, `create_time`, `update_time`) VALUES (100029, 100000, '李东', 1, 2, 600015, 0.01, NULL, '2025-05-27 00:36:52', '2025-05-27 00:36:52');
COMMIT;

-- ----------------------------
-- Table structure for tb_cate
-- ----------------------------
DROP TABLE IF EXISTS `tb_cate`;
CREATE TABLE `tb_cate` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分类名称',
  `pid` bigint DEFAULT '0' COMMENT '父分类id',
  `pids` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '所有上级ID，用逗号分开',
  `status` int DEFAULT '0' COMMENT '是否上架：0否，1是',
  `hot` int DEFAULT '0' COMMENT '是否热门：0否，1是',
  `sort` int DEFAULT '0' COMMENT '排序',
  `creator` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建者',
  `updater` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100005 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='项目分类表';

-- ----------------------------
-- Records of tb_cate
-- ----------------------------
BEGIN;
INSERT INTO `tb_cate` (`id`, `name`, `pid`, `pids`, `status`, `hot`, `sort`, `creator`, `updater`, `create_time`, `update_time`) VALUES (100000, 'SEM', 0, '0', 1, 1, 1, NULL, NULL, NULL, '2025-05-09 09:42:52');
INSERT INTO `tb_cate` (`id`, `name`, `pid`, `pids`, `status`, `hot`, `sort`, `creator`, `updater`, `create_time`, `update_time`) VALUES (100001, 'EBSD', 0, '0', 1, 1, 2, NULL, NULL, NULL, '2025-05-09 09:43:03');
INSERT INTO `tb_cate` (`id`, `name`, `pid`, `pids`, `status`, `hot`, `sort`, `creator`, `updater`, `create_time`, `update_time`) VALUES (100002, 'XRD', 0, '0', 1, 1, 3, NULL, NULL, '2025-05-08 10:04:07', '2025-05-09 09:43:12');
INSERT INTO `tb_cate` (`id`, `name`, `pid`, `pids`, `status`, `hot`, `sort`, `creator`, `updater`, `create_time`, `update_time`) VALUES (100003, '制样', 0, '0', 1, 1, 4, NULL, NULL, '2025-05-08 10:05:27', '2025-05-09 09:43:21');
INSERT INTO `tb_cate` (`id`, `name`, `pid`, `pids`, `status`, `hot`, `sort`, `creator`, `updater`, `create_time`, `update_time`) VALUES (100004, '其它分类', 0, '0', 0, 0, 5, NULL, NULL, '2025-05-08 10:05:37', '2025-05-08 10:05:37');
COMMIT;

-- ----------------------------
-- Table structure for tb_coupons
-- ----------------------------
DROP TABLE IF EXISTS `tb_coupons`;
CREATE TABLE `tb_coupons` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标题',
  `content` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '内容',
  `url` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '链接',
  `num` int DEFAULT NULL COMMENT '优惠券数量',
  `received` int DEFAULT NULL COMMENT '已领取数量',
  `rank` int DEFAULT NULL COMMENT '排序',
  `image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图片',
  `status` int DEFAULT '0' COMMENT '是否结束:0否，1是',
  `type` int DEFAULT NULL COMMENT '优惠券类型，0：无门槛，1满减',
  `min_amount` decimal(10,2) DEFAULT NULL COMMENT '最少金额',
  `discount` decimal(10,2) DEFAULT NULL COMMENT '优惠金额',
  `start_time` datetime DEFAULT NULL COMMENT '开始时间',
  `end_time` datetime DEFAULT NULL COMMENT '结束时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='优惠券管理';

-- ----------------------------
-- Records of tb_coupons
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tb_coupons_logs
-- ----------------------------
DROP TABLE IF EXISTS `tb_coupons_logs`;
CREATE TABLE `tb_coupons_logs` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `coupons_id` bigint DEFAULT NULL COMMENT '优惠券id',
  `user_id` bigint DEFAULT NULL COMMENT '用户id',
  `username` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户名称',
  `status` int DEFAULT '0' COMMENT '是否使用:0否，1是',
  `order_id` bigint DEFAULT NULL COMMENT '订单id',
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称标题',
  `start_time` datetime DEFAULT NULL COMMENT '开始时间',
  `end_time` datetime DEFAULT NULL COMMENT '结束时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='优惠券日志';

-- ----------------------------
-- Records of tb_coupons_logs
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tb_invoice
-- ----------------------------
DROP TABLE IF EXISTS `tb_invoice`;
CREATE TABLE `tb_invoice` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint DEFAULT NULL COMMENT '用户id',
  `username` varbinary(255) DEFAULT NULL COMMENT '用户名称',
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '公司名称',
  `no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '税号',
  `bank` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '开户行',
  `bank_account` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '银行账号',
  `address` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '公司地址',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '公司电话',
  `is_default` int DEFAULT '0' COMMENT '是否默认，0否，1是',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=300002 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='发票管理';

-- ----------------------------
-- Records of tb_invoice
-- ----------------------------
BEGIN;
INSERT INTO `tb_invoice` (`id`, `user_id`, `username`, `title`, `no`, `bank`, `bank_account`, `address`, `phone`, `is_default`, `create_time`, `update_time`) VALUES (300000, 100000, 0xE69D8EE4B89C, '土地勘探公司', '84326795189', '河南建行', '3241179886489986', '河南漯河', '8679845139', 1, '2025-05-21 20:26:07', '2025-05-21 20:26:07');
INSERT INTO `tb_invoice` (`id`, `user_id`, `username`, `title`, `no`, `bank`, `bank_account`, `address`, `phone`, `is_default`, `create_time`, `update_time`) VALUES (300001, 100001, 0xE4BA8EE4BF8AE9BE99, '漯河双汇公司', '8695265625', '中原银行', '65253588556565', '漯河市源汇区干河陈', '189365566', 1, '2025-05-21 23:23:21', '2025-05-21 23:23:21');
COMMIT;

-- ----------------------------
-- Table structure for tb_invoice_logs
-- ----------------------------
DROP TABLE IF EXISTS `tb_invoice_logs`;
CREATE TABLE `tb_invoice_logs` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `business_type` int DEFAULT NULL COMMENT '类型：0用户充值，1组充值，2订单支付',
  `business_id` bigint DEFAULT NULL COMMENT '业务id',
  `invoice_id` bigint DEFAULT NULL COMMENT '发票id',
  `invoice_type` int DEFAULT NULL COMMENT '类型：0普票（电子），1专票（电子）',
  `amount` decimal(10,2) DEFAULT NULL COMMENT '总金额',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '电子发票文件url',
  `status` int DEFAULT '0' COMMENT '状态：充值时：0未支付，1支付成功，可开票，2已开票 \n订单时：0申请，1通过，2已开票。',
  `file_type` int DEFAULT NULL COMMENT '0合同，1检测清单，2检测报告',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户名称',
  `user_id` bigint DEFAULT NULL COMMENT '用户id',
  `note` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `transaction_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '支付交易id',
  `pay_result` text COLLATE utf8mb4_general_ci COMMENT '交易结果',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100030 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='发票日志';

-- ----------------------------
-- Records of tb_invoice_logs
-- ----------------------------
BEGIN;
INSERT INTO `tb_invoice_logs` (`id`, `business_type`, `business_id`, `invoice_id`, `invoice_type`, `amount`, `url`, `status`, `file_type`, `username`, `user_id`, `note`, `create_time`, `update_time`, `transaction_id`, `pay_result`) VALUES (100019, 1, 200000, 300000, 0, 0.05, NULL, 1, 2, '李东', 100000, '河南检测组，第一笔充值', '2025-05-21 20:26:56', '2025-05-21 20:26:56', '4200002732202505211986122026', '{\"mchid\":\"1717390286\",\"appid\":\"wx8cd282afbaaaa274\",\"out_trade_no\":\"100019\",\"transaction_id\":\"4200002732202505211986122026\",\"trade_type\":\"JSAPI\",\"trade_state\":\"SUCCESS\",\"trade_state_desc\":\"支付成功\",\"bank_type\":\"OTHERS\",\"attach\":\"1\",\"success_time\":\"2025-05-21T20:27:00+08:00\",\"payer\":{\"openid\":\"o6SAF7AazblqjHstn0KzfqoW2ojA\"},\"amount\":{\"total\":5,\"payer_total\":5,\"currency\":\"CNY\",\"payer_currency\":\"CNY\"}}');
INSERT INTO `tb_invoice_logs` (`id`, `business_type`, `business_id`, `invoice_id`, `invoice_type`, `amount`, `url`, `status`, `file_type`, `username`, `user_id`, `note`, `create_time`, `update_time`, `transaction_id`, `pay_result`) VALUES (100020, 2, 600000, NULL, NULL, 0.01, NULL, 1, NULL, '李东', 100000, NULL, '2025-05-21 20:37:46', '2025-05-21 20:37:46', '4200002653202505210384632467', '{\"mchid\":\"1717390286\",\"appid\":\"wx8cd282afbaaaa274\",\"out_trade_no\":\"100020\",\"transaction_id\":\"4200002653202505210384632467\",\"trade_type\":\"JSAPI\",\"trade_state\":\"SUCCESS\",\"trade_state_desc\":\"支付成功\",\"bank_type\":\"OTHERS\",\"attach\":\"2\",\"success_time\":\"2025-05-21T20:37:51+08:00\",\"payer\":{\"openid\":\"o6SAF7AazblqjHstn0KzfqoW2ojA\"},\"amount\":{\"total\":1,\"payer_total\":1,\"currency\":\"CNY\",\"payer_currency\":\"CNY\"}}');
INSERT INTO `tb_invoice_logs` (`id`, `business_type`, `business_id`, `invoice_id`, `invoice_type`, `amount`, `url`, `status`, `file_type`, `username`, `user_id`, `note`, `create_time`, `update_time`, `transaction_id`, `pay_result`) VALUES (100021, 0, NULL, 300000, 0, 0.06, NULL, 1, 1, '李东', 100000, '个人充值', '2025-05-21 22:40:44', '2025-05-21 22:40:44', '4200002738202505218017878076', '{\"mchid\":\"1717390286\",\"appid\":\"wx8cd282afbaaaa274\",\"out_trade_no\":\"100021\",\"transaction_id\":\"4200002738202505218017878076\",\"trade_type\":\"JSAPI\",\"trade_state\":\"SUCCESS\",\"trade_state_desc\":\"支付成功\",\"bank_type\":\"OTHERS\",\"attach\":\"0\",\"success_time\":\"2025-05-21T22:40:49+08:00\",\"payer\":{\"openid\":\"o6SAF7AazblqjHstn0KzfqoW2ojA\"},\"amount\":{\"total\":6,\"payer_total\":6,\"currency\":\"CNY\",\"payer_currency\":\"CNY\"}}');
INSERT INTO `tb_invoice_logs` (`id`, `business_type`, `business_id`, `invoice_id`, `invoice_type`, `amount`, `url`, `status`, `file_type`, `username`, `user_id`, `note`, `create_time`, `update_time`, `transaction_id`, `pay_result`) VALUES (100022, 2, 600002, NULL, NULL, 0.01, NULL, 1, NULL, '于俊龙', 100001, NULL, '2025-05-21 23:00:14', '2025-05-21 23:00:14', '4200002742202505215471109269', '{\"mchid\":\"1717390286\",\"appid\":\"wx8cd282afbaaaa274\",\"out_trade_no\":\"100022\",\"transaction_id\":\"4200002742202505215471109269\",\"trade_type\":\"JSAPI\",\"trade_state\":\"SUCCESS\",\"trade_state_desc\":\"支付成功\",\"bank_type\":\"CMB_CREDIT\",\"attach\":\"2\",\"success_time\":\"2025-05-21T23:00:20+08:00\",\"payer\":{\"openid\":\"o6SAF7CJDmMK9GZIZxHgtPLpfua0\"},\"amount\":{\"total\":1,\"payer_total\":1,\"currency\":\"CNY\",\"payer_currency\":\"CNY\"}}');
INSERT INTO `tb_invoice_logs` (`id`, `business_type`, `business_id`, `invoice_id`, `invoice_type`, `amount`, `url`, `status`, `file_type`, `username`, `user_id`, `note`, `create_time`, `update_time`, `transaction_id`, `pay_result`) VALUES (100023, 0, NULL, 300001, 1, 0.02, NULL, 1, NULL, '于俊龙', 100001, '快点', '2025-05-21 23:23:41', '2025-05-21 23:23:41', '4200002744202505218159907076', '{\"mchid\":\"1717390286\",\"appid\":\"wx8cd282afbaaaa274\",\"out_trade_no\":\"100023\",\"transaction_id\":\"4200002744202505218159907076\",\"trade_type\":\"JSAPI\",\"trade_state\":\"SUCCESS\",\"trade_state_desc\":\"支付成功\",\"bank_type\":\"CMB_CREDIT\",\"attach\":\"0\",\"success_time\":\"2025-05-21T23:23:47+08:00\",\"payer\":{\"openid\":\"o6SAF7CJDmMK9GZIZxHgtPLpfua0\"},\"amount\":{\"total\":2,\"payer_total\":2,\"currency\":\"CNY\",\"payer_currency\":\"CNY\"}}');
INSERT INTO `tb_invoice_logs` (`id`, `business_type`, `business_id`, `invoice_id`, `invoice_type`, `amount`, `url`, `status`, `file_type`, `username`, `user_id`, `note`, `create_time`, `update_time`, `transaction_id`, `pay_result`) VALUES (100024, 2, 600007, NULL, NULL, 0.01, NULL, 0, NULL, '李东', 100000, NULL, '2025-05-22 00:21:58', '2025-05-22 00:21:58', NULL, NULL);
INSERT INTO `tb_invoice_logs` (`id`, `business_type`, `business_id`, `invoice_id`, `invoice_type`, `amount`, `url`, `status`, `file_type`, `username`, `user_id`, `note`, `create_time`, `update_time`, `transaction_id`, `pay_result`) VALUES (100025, 2, 600007, NULL, NULL, 0.01, 'http://localhost:8001/public/file/invoice/6ad4cce5e0434b4aa983bdf0c0b03996.webp', 2, NULL, '李东', 100000, NULL, '2025-05-22 00:23:59', '2025-05-22 00:23:59', '4200002733202505228053594892', '{\"mchid\":\"1717390286\",\"appid\":\"wx8cd282afbaaaa274\",\"out_trade_no\":\"100025\",\"transaction_id\":\"4200002733202505228053594892\",\"trade_type\":\"JSAPI\",\"trade_state\":\"SUCCESS\",\"trade_state_desc\":\"支付成功\",\"bank_type\":\"OTHERS\",\"attach\":\"2\",\"success_time\":\"2025-05-22T00:24:12+08:00\",\"payer\":{\"openid\":\"o6SAF7AazblqjHstn0KzfqoW2ojA\"},\"amount\":{\"total\":1,\"payer_total\":1,\"currency\":\"CNY\",\"payer_currency\":\"CNY\"}}');
INSERT INTO `tb_invoice_logs` (`id`, `business_type`, `business_id`, `invoice_id`, `invoice_type`, `amount`, `url`, `status`, `file_type`, `username`, `user_id`, `note`, `create_time`, `update_time`, `transaction_id`, `pay_result`) VALUES (100026, 3, NULL, 300001, 0, 600.00, NULL, 1, NULL, '于俊龙', 100001, NULL, '2025-05-23 17:09:13', '2025-05-23 17:09:13', NULL, NULL);
INSERT INTO `tb_invoice_logs` (`id`, `business_type`, `business_id`, `invoice_id`, `invoice_type`, `amount`, `url`, `status`, `file_type`, `username`, `user_id`, `note`, `create_time`, `update_time`, `transaction_id`, `pay_result`) VALUES (100027, 3, 600002, 300001, 1, 0.01, NULL, 1, 1, '于俊龙', 100001, 'EBSD', '2025-05-23 17:19:11', '2025-05-23 17:19:11', NULL, NULL);
INSERT INTO `tb_invoice_logs` (`id`, `business_type`, `business_id`, `invoice_id`, `invoice_type`, `amount`, `url`, `status`, `file_type`, `username`, `user_id`, `note`, `create_time`, `update_time`, `transaction_id`, `pay_result`) VALUES (100028, 3, 600002, 300001, 0, 0.01, NULL, 1, 1, '于俊龙', 100001, 'EBSD', '2025-05-23 17:20:22', '2025-05-23 17:20:22', NULL, NULL);
INSERT INTO `tb_invoice_logs` (`id`, `business_type`, `business_id`, `invoice_id`, `invoice_type`, `amount`, `url`, `status`, `file_type`, `username`, `user_id`, `note`, `create_time`, `update_time`, `transaction_id`, `pay_result`) VALUES (100029, 2, 600015, NULL, NULL, 0.01, NULL, 1, NULL, '李东', 100000, NULL, '2025-05-27 00:36:46', '2025-05-27 00:36:46', '4200002659202505272922036870', '{\"mchid\":\"1717390286\",\"appid\":\"wx8cd282afbaaaa274\",\"out_trade_no\":\"100029\",\"transaction_id\":\"4200002659202505272922036870\",\"trade_type\":\"JSAPI\",\"trade_state\":\"SUCCESS\",\"trade_state_desc\":\"支付成功\",\"bank_type\":\"OTHERS\",\"attach\":\"2\",\"success_time\":\"2025-05-27T00:36:51+08:00\",\"payer\":{\"openid\":\"o6SAF7AazblqjHstn0KzfqoW2ojA\"},\"amount\":{\"total\":1,\"payer_total\":1,\"currency\":\"CNY\",\"payer_currency\":\"CNY\"}}');
COMMIT;

-- ----------------------------
-- Table structure for tb_machine
-- ----------------------------
DROP TABLE IF EXISTS `tb_machine`;
CREATE TABLE `tb_machine` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图片',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '内容',
  `status` int DEFAULT '0' COMMENT '状态：0维修，1可用',
  `type` int DEFAULT '1' COMMENT '时间互斥：0否，1是',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='机器表';

-- ----------------------------
-- Records of tb_machine
-- ----------------------------
BEGIN;
INSERT INTO `tb_machine` (`id`, `name`, `image`, `content`, `status`, `type`, `create_time`, `update_time`) VALUES (1, '电镜1（Nordlys）', 'http://101.126.90.44/file/machine/5ad6b318f4e84816bce90d88fb077ccf.jpg', '<p>这个设置可以做纸涨的检测，测试g</p><p><br></p><p><br></p><p>dsdf</p><p>说明</p>', 1, 1, '2025-04-22 01:09:19', '2025-05-14 15:20:07');
INSERT INTO `tb_machine` (`id`, `name`, `image`, `content`, `status`, `type`, `create_time`, `update_time`) VALUES (2, '电镜（Symmetry-s3）', 'http://101.126.90.44/file/machine/1c4cf055b41c45a7b2d59494a1dc7bd4.png', '<p>测试co2的机器</p><p><br></p>', 1, 1, '2025-04-23 17:47:45', '2025-05-14 15:20:13');
INSERT INTO `tb_machine` (`id`, `name`, `image`, `content`, `status`, `type`, `create_time`, `update_time`) VALUES (3, '制样', 'http://101.126.90.44/file/machine/zhiyang.jpg', '<p>制样的机器</p><p><br></p>', 1, 0, '2025-05-14 15:29:24', '2025-05-14 15:29:33');
INSERT INTO `tb_machine` (`id`, `name`, `image`, `content`, `status`, `type`, `create_time`, `update_time`) VALUES (4, '拉伸-压缩', 'http://101.126.90.44/file/machine/b37f59a6caca421daa7e4510bac8712e.jpg', '<p style=\"text-indent: 0px; text-align: start;\">&nbsp;&nbsp;&nbsp;&nbsp;电子万能试验机能测试金属或非金属拉伸、压缩、弯曲、剪切等各种力学项目，是控制、测量、操作一体化结构，融当代先进技术于一体，具有精度高、调速范围宽、结构紧凑、操作方便、性能稳定等优点。</p><p style=\"text-indent: 0px; text-align: start;\">&nbsp;&nbsp;&nbsp;&nbsp;广泛应用于各种金属、非金属、复合材料、医药、食品、木材、铜材、铝材、电线电缆、纸张、塑料材类、薄膜、橡胶、纺织、航空航天等行业，能进行各种力学性能指标的测试。</p>', 1, 0, '2025-05-26 15:15:40', '2025-05-26 15:15:40');
COMMIT;

-- ----------------------------
-- Table structure for tb_order
-- ----------------------------
DROP TABLE IF EXISTS `tb_order`;
CREATE TABLE `tb_order` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `project_id` bigint DEFAULT NULL COMMENT '项目id',
  `project_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '项目名称',
  `machine_id` bigint DEFAULT NULL COMMENT '机器id',
  `machine_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '机器名称',
  `cate_id` bigint DEFAULT NULL COMMENT '分类id',
  `cate_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分类名称',
  `contacts` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '联系人',
  `phone` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '联系人电话',
  `book_all_times` tinytext COLLATE utf8mb4_general_ci COMMENT '所有预约时间',
  `book_total_time` decimal(10,2) DEFAULT NULL COMMENT '总的工时(如2.5小时）',
  `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '样品名称',
  `way` int DEFAULT '1' COMMENT '取样方式：0到场取样，1快递取样，2自行送样',
  `note` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '样品备注',
  `recycle` int DEFAULT NULL COMMENT '是否回收：0需要，1不需要',
  `recycle_detail` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '回收详情，地址和联系方式',
  `user_id` bigint DEFAULT NULL COMMENT '预约人Id',
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '预约人名称',
  `team_id` bigint DEFAULT NULL COMMENT '团队id',
  `team_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '团队名称',
  `team_review` int DEFAULT '0' COMMENT '审核：0审核，1通过，2不通过',
  `status` int DEFAULT '0' COMMENT '状态：0待收样，1进行中，2待确认，3待支付，4已完成，10拒绝',
  `bk_id` bigint DEFAULT NULL COMMENT '技术员用户Id',
  `bk_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '技术员用户名称',
  `sign` int DEFAULT '0' COMMENT '客户是否签字：0否，1是',
  `sign_image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '客户签字图片url',
  `pay_type` int DEFAULT NULL COMMENT '支付类型：0个人，1组',
  `pay_way` int DEFAULT NULL COMMENT '支付方式：0个人余额，1组余额，2微信支付 ',
  `pre_amount` decimal(10,2) DEFAULT NULL COMMENT '预计金额',
  `amount` decimal(10,2) DEFAULT NULL COMMENT '总金额',
  `actual_amount` decimal(10,2) DEFAULT NULL COMMENT '实际金额',
  `is_invoice` int DEFAULT '0' COMMENT '是否开发票：0否，1是',
  `invoice_id` bigint DEFAULT '0' COMMENT '发票抬头id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `book_time` date DEFAULT NULL COMMENT '预约时间(日期)',
  `book_start_time` time DEFAULT NULL COMMENT '预约开始时间',
  `book_end_time` time DEFAULT NULL COMMENT '预约结束时间',
  `reports` text COLLATE utf8mb4_general_ci COMMENT '报告url，多个以逗号分开',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=600017 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='预约列表';

-- ----------------------------
-- Records of tb_order
-- ----------------------------
BEGIN;
INSERT INTO `tb_order` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `cate_id`, `cate_name`, `contacts`, `phone`, `book_all_times`, `book_total_time`, `name`, `way`, `note`, `recycle`, `recycle_detail`, `user_id`, `user_name`, `team_id`, `team_name`, `team_review`, `status`, `bk_id`, `bk_name`, `sign`, `sign_image`, `pay_type`, `pay_way`, `pre_amount`, `amount`, `actual_amount`, `is_invoice`, `invoice_id`, `create_time`, `update_time`, `book_time`, `book_start_time`, `book_end_time`, `reports`) VALUES (600000, 1, 'SEM', 1, '电镜1（Nordlys）', NULL, NULL, '李一', '1760000001', '2025-05-22 08:00,2025-05-22 08:30,2025-05-22 09:00,2025-05-22 09:30', 4.00, NULL, 0, '个人预约第一次', 1, '', 100000, '李东', NULL, NULL, 0, 4, NULL, NULL, 1, 'http://101.126.90.44/file/sign/a7fb7b09779f43fa8f96591a0d4fd3bb.png', NULL, 2, NULL, 400.00, 0.01, 0, 0, '2025-05-21 20:35:44', '2025-05-21 20:37:00', NULL, NULL, NULL, NULL);
INSERT INTO `tb_order` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `cate_id`, `cate_name`, `contacts`, `phone`, `book_all_times`, `book_total_time`, `name`, `way`, `note`, `recycle`, `recycle_detail`, `user_id`, `user_name`, `team_id`, `team_name`, `team_review`, `status`, `bk_id`, `bk_name`, `sign`, `sign_image`, `pay_type`, `pay_way`, `pre_amount`, `amount`, `actual_amount`, `is_invoice`, `invoice_id`, `create_time`, `update_time`, `book_time`, `book_start_time`, `book_end_time`, `reports`) VALUES (600001, 4, 'TKD', 1, '电镜1（Nordlys）', NULL, NULL, '李二', '17600000002', '2025-05-22 08:00,2025-05-22 08:30', 2.00, NULL, 0, '李二请求', 1, '', 100000, '李东', 200000, '河南检测组', 1, 4, NULL, NULL, 1, 'http://101.126.90.44/file/sign/3ffcaf9f06924aa4bd2808d2adc42b4c.png', NULL, 1, NULL, 600.00, 0.01, 0, 0, '2025-05-21 21:44:38', '2025-05-21 22:32:50', NULL, NULL, NULL, NULL);
INSERT INTO `tb_order` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `cate_id`, `cate_name`, `contacts`, `phone`, `book_all_times`, `book_total_time`, `name`, `way`, `note`, `recycle`, `recycle_detail`, `user_id`, `user_name`, `team_id`, `team_name`, `team_review`, `status`, `bk_id`, `bk_name`, `sign`, `sign_image`, `pay_type`, `pay_way`, `pre_amount`, `amount`, `actual_amount`, `is_invoice`, `invoice_id`, `create_time`, `update_time`, `book_time`, `book_start_time`, `book_end_time`, `reports`) VALUES (600002, 2, 'EBSD', 1, '电镜1（Nordlys）', NULL, NULL, '于俊龙', '19087667890', '2025-05-22 10:00,2025-05-22 11:30', 2.00, NULL, 0, '不错哦', 1, '', 100001, '于俊龙', 200000, '河南检测组', 1, 4, NULL, NULL, 1, 'http://101.126.90.44/file/sign/95cee711ae9b4c21b12c3bc4d95fde08.png', NULL, 2, NULL, 400.00, 0.01, 0, 0, '2025-05-21 22:55:47', '2025-05-21 22:57:05', NULL, NULL, NULL, NULL);
INSERT INTO `tb_order` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `cate_id`, `cate_name`, `contacts`, `phone`, `book_all_times`, `book_total_time`, `name`, `way`, `note`, `recycle`, `recycle_detail`, `user_id`, `user_name`, `team_id`, `team_name`, `team_review`, `status`, `bk_id`, `bk_name`, `sign`, `sign_image`, `pay_type`, `pay_way`, `pre_amount`, `amount`, `actual_amount`, `is_invoice`, `invoice_id`, `create_time`, `update_time`, `book_time`, `book_start_time`, `book_end_time`, `reports`) VALUES (600003, 2, 'EBSD', 1, '电镜1（Nordlys）', NULL, NULL, '李三', '17033333333', '2025-05-22 11:00,2025-05-22 11:30', 2.00, NULL, 0, '李三的订单', 1, '', 100000, '李东', 200000, '河南检测组', 1, 4, NULL, NULL, 1, 'http://101.126.90.44/file/sign/e1462df7d30c406897527c28fd4877d5.png', NULL, 0, NULL, 400.00, 0.03, 0, 0, '2025-05-21 23:09:07', '2025-05-21 23:18:46', NULL, NULL, NULL, NULL);
INSERT INTO `tb_order` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `cate_id`, `cate_name`, `contacts`, `phone`, `book_all_times`, `book_total_time`, `name`, `way`, `note`, `recycle`, `recycle_detail`, `user_id`, `user_name`, `team_id`, `team_name`, `team_review`, `status`, `bk_id`, `bk_name`, `sign`, `sign_image`, `pay_type`, `pay_way`, `pre_amount`, `amount`, `actual_amount`, `is_invoice`, `invoice_id`, `create_time`, `update_time`, `book_time`, `book_start_time`, `book_end_time`, `reports`) VALUES (600004, 3, 'EDS', 1, '电镜1（Nordlys）', NULL, NULL, '漯河龙', '198088778998', '2025-05-21 23:30,2025-05-22 16:00,2025-05-23 15:30', 3.00, NULL, 0, '', 1, '', 100001, '于俊龙', NULL, NULL, 0, 4, NULL, NULL, 1, 'http://101.126.90.44/file/sign/ceaa6105fb2a4d3d9ba5fdd95ca4f131.png', NULL, 0, NULL, 630.00, 0.02, 0, 0, '2025-05-21 23:13:08', '2025-05-26 14:47:23', NULL, NULL, NULL, '[{\"name\":\"2_K线动能和五段锦精华.pdf\",\"percentage\":100,\"status\":\"success\",\"size\":1690686,\"raw\":{\"uid\":1748241612522},\"uid\":1748241612522,\"response\":{\"code\":0,\"msg\":\"success\",\"data\":{\"name\":\"ba2f7d193d4f4e2ea72d24770e70e9d9.pdf\",\"url\":\"http://101.126.90.44/file/reports/ba2f7d193d4f4e2ea72d24770e70e9d9.pdf\"}}},{\"name\":\"eds.jpg\",\"percentage\":100,\"status\":\"success\",\"size\":12904,\"raw\":{\"uid\":1748242040920},\"uid\":1748242040920,\"response\":{\"code\":0,\"msg\":\"success\",\"data\":{\"name\":\"c46f7aa86a514681be18c027ad69de03.jpg\",\"url\":\"http://101.126.90.44/file/reports/c46f7aa86a514681be18c027ad69de03.jpg\"}}}]');
INSERT INTO `tb_order` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `cate_id`, `cate_name`, `contacts`, `phone`, `book_all_times`, `book_total_time`, `name`, `way`, `note`, `recycle`, `recycle_detail`, `user_id`, `user_name`, `team_id`, `team_name`, `team_review`, `status`, `bk_id`, `bk_name`, `sign`, `sign_image`, `pay_type`, `pay_way`, `pre_amount`, `amount`, `actual_amount`, `is_invoice`, `invoice_id`, `create_time`, `update_time`, `book_time`, `book_start_time`, `book_end_time`, `reports`) VALUES (600005, 4, 'TKD', 1, '电镜1（Nordlys）', NULL, NULL, '鱼笑汗', '15695225365', '2025-05-21 23:30,2025-05-22 15:30', 2.00, NULL, 0, '快点啊', 1, '', 100002, '于肖涵', NULL, NULL, 0, 9, NULL, NULL, 0, NULL, NULL, 0, NULL, 600.00, 600.00, 0, 0, '2025-05-21 23:53:16', '2025-05-21 23:53:16', NULL, NULL, NULL, NULL);
INSERT INTO `tb_order` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `cate_id`, `cate_name`, `contacts`, `phone`, `book_all_times`, `book_total_time`, `name`, `way`, `note`, `recycle`, `recycle_detail`, `user_id`, `user_name`, `team_id`, `team_name`, `team_review`, `status`, `bk_id`, `bk_name`, `sign`, `sign_image`, `pay_type`, `pay_way`, `pre_amount`, `amount`, `actual_amount`, `is_invoice`, `invoice_id`, `create_time`, `update_time`, `book_time`, `book_start_time`, `book_end_time`, `reports`) VALUES (600006, 1, 'SEM', 1, '电镜1（Nordlys）', NULL, NULL, '李4', '1744444444', '2025-05-22 06:30,2025-05-22 07:00', 2.00, NULL, 0, '不回收', 1, '', 100000, '李东', NULL, NULL, 0, 4, NULL, NULL, 1, 'http://101.126.90.44/file/sign/6c6773ae646c46ce94073578b178b63d.png', NULL, 0, NULL, 200.00, 0.01, 0, 0, '2025-05-22 00:08:37', '2025-05-22 00:11:16', NULL, NULL, NULL, NULL);
INSERT INTO `tb_order` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `cate_id`, `cate_name`, `contacts`, `phone`, `book_all_times`, `book_total_time`, `name`, `way`, `note`, `recycle`, `recycle_detail`, `user_id`, `user_name`, `team_id`, `team_name`, `team_review`, `status`, `bk_id`, `bk_name`, `sign`, `sign_image`, `pay_type`, `pay_way`, `pre_amount`, `amount`, `actual_amount`, `is_invoice`, `invoice_id`, `create_time`, `update_time`, `book_time`, `book_start_time`, `book_end_time`, `reports`) VALUES (600007, 3, 'EDS', 1, '电镜1（Nordlys）', NULL, NULL, '李5', '1755555555', '2025-05-22 06:30,2025-05-22 07:00', 2.00, NULL, 0, '李55555', 1, '', 100000, '李东', NULL, NULL, 0, 4, NULL, NULL, 1, 'http://101.126.90.44/file/sign/239862d61ae645ddb024ecc3297a769d.png', NULL, 2, NULL, 420.00, 0.01, 0, 0, '2025-05-22 00:13:42', '2025-05-23 22:18:28', NULL, NULL, NULL, '[{\"name\":\"tkd.png\",\"percentage\":100,\"status\":\"success\",\"size\":175880,\"raw\":{\"uid\":1748009881065},\"uid\":1748009881065,\"response\":{\"code\":0,\"msg\":\"success\",\"data\":{\"name\":\"944d33ace542481eaa7f4b4dd57c7f76.png\",\"url\":\"http://localhost:8001/public/file/reports/944d33ace542481eaa7f4b4dd57c7f76.png\"}}},{\"name\":\"zhiyang.jpg\",\"percentage\":100,\"status\":\"success\",\"size\":19790,\"raw\":{\"uid\":1748009881070},\"uid\":1748009881070,\"response\":{\"code\":0,\"msg\":\"success\",\"data\":{\"name\":\"db9cd115a41543499df85614af735574.jpg\",\"url\":\"http://localhost:8001/public/file/reports/db9cd115a41543499df85614af735574.jpg\"}}}]');
INSERT INTO `tb_order` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `cate_id`, `cate_name`, `contacts`, `phone`, `book_all_times`, `book_total_time`, `name`, `way`, `note`, `recycle`, `recycle_detail`, `user_id`, `user_name`, `team_id`, `team_name`, `team_review`, `status`, `bk_id`, `bk_name`, `sign`, `sign_image`, `pay_type`, `pay_way`, `pre_amount`, `amount`, `actual_amount`, `is_invoice`, `invoice_id`, `create_time`, `update_time`, `book_time`, `book_start_time`, `book_end_time`, `reports`) VALUES (600009, 1, 'SEM', 1, '电镜1（Nordlys）', NULL, NULL, '李5', '1555555555', '2025-05-22 23:00,2025-05-22 23:30', 2.00, NULL, 0, '', 0, '', 100000, '李东', NULL, NULL, 0, 4, 1925810359229501441, 'yjl11', 1, 'http://101.126.90.44/file/sign/e088ad18d2be418d94897586ac4d0fc4.png', NULL, 0, NULL, 100.00, 0.01, 0, 0, '2025-05-22 15:36:26', '2025-05-26 16:15:32', NULL, NULL, NULL, '[{\"name\":\"三十六计详解.docx\",\"percentage\":100,\"status\":\"success\",\"size\":20080,\"raw\":{\"uid\":1748011790362},\"uid\":1748011790362,\"response\":{\"code\":0,\"msg\":\"success\",\"data\":{\"name\":\"4247ede6c80a48be857dd8dcfe264e38.docx\",\"url\":\"http://101.126.90.44/file/reports/4247ede6c80a48be857dd8dcfe264e38.docx\"}}}]');
INSERT INTO `tb_order` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `cate_id`, `cate_name`, `contacts`, `phone`, `book_all_times`, `book_total_time`, `name`, `way`, `note`, `recycle`, `recycle_detail`, `user_id`, `user_name`, `team_id`, `team_name`, `team_review`, `status`, `bk_id`, `bk_name`, `sign`, `sign_image`, `pay_type`, `pay_way`, `pre_amount`, `amount`, `actual_amount`, `is_invoice`, `invoice_id`, `create_time`, `update_time`, `book_time`, `book_start_time`, `book_end_time`, `reports`) VALUES (600010, 1, 'SEM', 1, '电镜1（Nordlys）', NULL, NULL, '李东', '18701538908', '2025-05-24 19:00,2025-05-24 19:30,2025-05-24 20:00', 3.00, NULL, 0, '', 0, '', 100000, '李东', NULL, NULL, 0, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, 300.00, 0.01, 0, 0, '2025-05-24 12:43:54', '2025-05-24 12:43:54', NULL, NULL, NULL, NULL);
INSERT INTO `tb_order` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `cate_id`, `cate_name`, `contacts`, `phone`, `book_all_times`, `book_total_time`, `name`, `way`, `note`, `recycle`, `recycle_detail`, `user_id`, `user_name`, `team_id`, `team_name`, `team_review`, `status`, `bk_id`, `bk_name`, `sign`, `sign_image`, `pay_type`, `pay_way`, `pre_amount`, `amount`, `actual_amount`, `is_invoice`, `invoice_id`, `create_time`, `update_time`, `book_time`, `book_start_time`, `book_end_time`, `reports`) VALUES (600011, 1, 'SEM', 1, '电镜1（Nordlys）', NULL, NULL, '1111', '222222', '2025-05-24 22:00,2025-05-24 23:30', 1.00, NULL, 1, '4444', 0, '11223', 100001, NULL, NULL, NULL, 0, 9, NULL, NULL, 0, NULL, NULL, 0, NULL, 200.00, 200.00, 0, 0, '2025-05-24 21:37:30', '2025-05-24 21:37:30', NULL, NULL, NULL, NULL);
INSERT INTO `tb_order` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `cate_id`, `cate_name`, `contacts`, `phone`, `book_all_times`, `book_total_time`, `name`, `way`, `note`, `recycle`, `recycle_detail`, `user_id`, `user_name`, `team_id`, `team_name`, `team_review`, `status`, `bk_id`, `bk_name`, `sign`, `sign_image`, `pay_type`, `pay_way`, `pre_amount`, `amount`, `actual_amount`, `is_invoice`, `invoice_id`, `create_time`, `update_time`, `book_time`, `book_start_time`, `book_end_time`, `reports`) VALUES (600012, 2, 'EBSD', 2, '电镜（Symmetry-s3）', NULL, NULL, '孙成龙', '18744008868', '2025-05-26 19:00,2025-05-26 19:30,2025-05-26 20:00,2025-05-26 20:30', 4.00, NULL, 0, NULL, 0, '陕西省西安市雁塔区', 100003, 'Solo', NULL, NULL, 0, 1, 1915085051610066945, 'lid', 0, NULL, NULL, 0, NULL, 800.00, 720.00, 0, 0, '2025-05-26 11:38:10', '2025-05-26 13:54:30', NULL, NULL, NULL, '[{\"name\":\"报告（测试）.pdf\",\"percentage\":100,\"status\":\"success\",\"size\":4711,\"raw\":{\"uid\":1748234843614},\"uid\":1748234843614,\"response\":{\"code\":0,\"msg\":\"success\",\"data\":{\"name\":\"617ed3b5f50c4e38aa835fc5435ccad6.pdf\",\"url\":\"http://101.126.90.44/file/reports/617ed3b5f50c4e38aa835fc5435ccad6.pdf\"}}}]');
INSERT INTO `tb_order` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `cate_id`, `cate_name`, `contacts`, `phone`, `book_all_times`, `book_total_time`, `name`, `way`, `note`, `recycle`, `recycle_detail`, `user_id`, `user_name`, `team_id`, `team_name`, `team_review`, `status`, `bk_id`, `bk_name`, `sign`, `sign_image`, `pay_type`, `pay_way`, `pre_amount`, `amount`, `actual_amount`, `is_invoice`, `invoice_id`, `create_time`, `update_time`, `book_time`, `book_start_time`, `book_end_time`, `reports`) VALUES (600013, 2, 'EBSD', 1, '电镜1（Nordlys）', NULL, NULL, '于俊龙', '18939556325', '2025-06-01 20:30,2025-06-01 20:00,2025-06-01 18:30,2025-06-01 19:00', 2.00, NULL, 1, '快点', 0, '河南省漯河市源汇区', 100001, '于俊龙', 200000, '河南检测组', 1, 0, NULL, NULL, 0, NULL, NULL, 1, NULL, 960.00, 960.00, 0, 0, '2025-05-26 17:24:39', '2025-05-26 17:24:39', NULL, NULL, NULL, NULL);
INSERT INTO `tb_order` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `cate_id`, `cate_name`, `contacts`, `phone`, `book_all_times`, `book_total_time`, `name`, `way`, `note`, `recycle`, `recycle_detail`, `user_id`, `user_name`, `team_id`, `team_name`, `team_review`, `status`, `bk_id`, `bk_name`, `sign`, `sign_image`, `pay_type`, `pay_way`, `pre_amount`, `amount`, `actual_amount`, `is_invoice`, `invoice_id`, `create_time`, `update_time`, `book_time`, `book_start_time`, `book_end_time`, `reports`) VALUES (600014, 2, 'EBSD', 2, '电镜（Symmetry-s3）', NULL, NULL, '田宇洁', '18503548288', '2025-05-27 12:30,2025-05-27 13:00', 1.00, NULL, 0, NULL, 1, '', 100006, '辣黑兔🐰', NULL, NULL, 0, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, 660.00, 660.00, 0, 0, '2025-05-26 17:57:48', '2025-05-26 17:57:48', NULL, NULL, NULL, NULL);
INSERT INTO `tb_order` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `cate_id`, `cate_name`, `contacts`, `phone`, `book_all_times`, `book_total_time`, `name`, `way`, `note`, `recycle`, `recycle_detail`, `user_id`, `user_name`, `team_id`, `team_name`, `team_review`, `status`, `bk_id`, `bk_name`, `sign`, `sign_image`, `pay_type`, `pay_way`, `pre_amount`, `amount`, `actual_amount`, `is_invoice`, `invoice_id`, `create_time`, `update_time`, `book_time`, `book_start_time`, `book_end_time`, `reports`) VALUES (600015, 11, '拉伸', 4, '拉伸-压缩', NULL, NULL, '李东', '18701538908', '2025-05-27 12:00,2025-05-27 12:30,2025-05-27 13:00,2025-05-27 13:30', 2.00, NULL, 0, '', 0, '', 100000, '李东', NULL, NULL, 0, 4, NULL, NULL, 1, 'http://101.126.90.44/file/sign/69d7cf72e6be442c9f2a553a2ba13bf9.png', NULL, 2, NULL, 200.00, 0.01, 0, 0, '2025-05-27 00:18:53', '2025-05-27 00:37:53', NULL, NULL, NULL, '[{\"name\":\"640.webp\",\"percentage\":100,\"status\":\"success\",\"size\":337706,\"raw\":{\"uid\":1748277470465},\"uid\":1748277470465,\"response\":{\"code\":0,\"msg\":\"success\",\"data\":{\"name\":\"ea82117df1b444d9ae31aa4c1194d374.webp\",\"url\":\"http://101.126.90.44/file/reports/ea82117df1b444d9ae31aa4c1194d374.webp\"}}}]');
INSERT INTO `tb_order` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `cate_id`, `cate_name`, `contacts`, `phone`, `book_all_times`, `book_total_time`, `name`, `way`, `note`, `recycle`, `recycle_detail`, `user_id`, `user_name`, `team_id`, `team_name`, `team_review`, `status`, `bk_id`, `bk_name`, `sign`, `sign_image`, `pay_type`, `pay_way`, `pre_amount`, `amount`, `actual_amount`, `is_invoice`, `invoice_id`, `create_time`, `update_time`, `book_time`, `book_start_time`, `book_end_time`, `reports`) VALUES (600016, 11, '拉伸', 4, '拉伸-压缩', NULL, NULL, '于俊龙', '1893966878', '', NULL, NULL, 0, '放大三分', 1, '', 100001, '于俊龙', NULL, NULL, 0, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, 50.00, 50.00, 0, 0, '2025-05-27 00:29:43', '2025-05-27 00:29:43', NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for tb_project
-- ----------------------------
DROP TABLE IF EXISTS `tb_project`;
CREATE TABLE `tb_project` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图片',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '内容',
  `standards` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '检测标准',
  `ranges` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '适用范围',
  `cate_id` bigint DEFAULT NULL COMMENT '分类id',
  `cate_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分类名称',
  `recommend` int DEFAULT '0' COMMENT '是否推荐：0否，1是',
  `price` decimal(10,2) DEFAULT NULL COMMENT '价格',
  `status` int DEFAULT '1' COMMENT '状态0下线，1上线',
  `note` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='检测项目表';

-- ----------------------------
-- Records of tb_project
-- ----------------------------
BEGIN;
INSERT INTO `tb_project` (`id`, `name`, `image`, `content`, `standards`, `ranges`, `cate_id`, `cate_name`, `recommend`, `price`, `status`, `note`, `create_time`, `update_time`) VALUES (1, 'SEM', 'http://101.126.90.44/file/project/sem.jpg', '<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;扫描电子显微镜（SEM）是利用二次电子和背散射电子信号，通过真空系统、电子束系统和成像系统获取被测样品本身的各种物理、化学性质的信息，如形貌、组成、晶体结构、电子结构和内部电场或磁场等的一种分析仪器，随着科学技术水平的提高，其放大倍数&nbsp;可达几十万倍，分辨率可达纳米级别，是形貌和成分分析领域极其重要的一种工具。</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;扫描电子显微镜是一种多功能的仪器，具有很多优越的性能，是用途最为广泛的一种仪器，例如：</p><p><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1.&nbsp;&nbsp;</strong>观察纳米材料的形貌，对纳米材料的组成进行成分分析；</p><p><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2.&nbsp;&nbsp;</strong>使用扫描电镜，能够对断裂机理进行分析归类，明确断裂的类型，并且对裂纹源位置和扩展方向作出判定，明确金属材料的主要断裂机理；</p><p><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3.&nbsp;&nbsp;</strong>生物试样观察电子照射面发生试样的损伤和污染程度很小，对观察某些生物试样来说意义重要；</p><p><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4.&nbsp;&nbsp;</strong>对样品室内装有加热、冷却、弯曲、拉伸和离子刻蚀等附件，可以利用扫描电镜观察相变、断烈等动态的变化过程。</p>', NULL, NULL, 100000, 'SEM', 1, NULL, 1, NULL, '2025-04-24 00:28:32', '2025-05-26 12:08:34');
INSERT INTO `tb_project` (`id`, `name`, `image`, `content`, `standards`, `ranges`, `cate_id`, `cate_name`, `recommend`, `price`, `status`, `note`, `create_time`, `update_time`) VALUES (2, 'EBSD', 'http://101.126.90.44/file/project/EBSD.jpg', '<p style=\"text-indent: 0px; text-align: start;\">EBSD具体分析功能：</p><p style=\"text-indent: 0px; text-align: start;\">1，微观组织分析：晶粒尺寸、均匀性、孪晶的体积分数、再结晶晶粒以及亚晶、晶界特性分析、相鉴定、相分布等；</p><p style=\"text-indent: 0px; text-align: start;\">2，取向分析：相邻晶粒的取向分析，晶粒和相邻孪晶的取向分析，孪晶以及相邻孪晶的取向分析，织构分析，取向差分析等。</p>', NULL, NULL, 100001, 'EBSD', 1, NULL, 1, NULL, '2025-04-24 00:28:50', '2025-05-26 12:16:54');
INSERT INTO `tb_project` (`id`, `name`, `image`, `content`, `standards`, `ranges`, `cate_id`, `cate_name`, `recommend`, `price`, `status`, `note`, `create_time`, `update_time`) VALUES (3, 'EDS', 'http://101.126.90.44/file/project/eds.jpg', '<p><strong>项目说明</strong></p><p>&nbsp;说明1</p><p><strong>项目简介</strong></p><p>2222222</p><p><strong>项目范围</strong></p><p>&nbsp;dssdfsd</p>', NULL, NULL, 100004, '其它分类', 1, NULL, 1, NULL, '2025-05-14 15:43:51', '2025-05-14 15:43:51');
INSERT INTO `tb_project` (`id`, `name`, `image`, `content`, `standards`, `ranges`, `cate_id`, `cate_name`, `recommend`, `price`, `status`, `note`, `create_time`, `update_time`) VALUES (4, 'TKD', 'http://101.126.90.44/file/project/98ee8ad9d10a4193805ab43841284bc2.png', '<p><strong>项目说明</strong></p><p>&nbsp;&nbsp;说明1</p><p><strong>项目简介</strong></p><p>&nbsp;2222222</p><p><strong>项目范围</strong></p><p>&nbsp;&nbsp;dssdfsd</p>', NULL, NULL, 100000, 'SEM', 0, NULL, 1, 'TKD 不能用于xxx', '2025-05-14 17:35:34', '2025-05-21 20:03:45');
INSERT INTO `tb_project` (`id`, `name`, `image`, `content`, `standards`, `ranges`, `cate_id`, `cate_name`, `recommend`, `price`, `status`, `note`, `create_time`, `update_time`) VALUES (5, 'ECCI', 'http://101.126.90.44/file/project/d706eebd668249af830ecac7d822a38f.jpeg', '<p>ECCI&nbsp;简介</p>', NULL, NULL, 100000, 'SEM', 0, NULL, 1, 'ECCI  备注', '2025-05-14 17:37:03', '2025-05-14 17:37:03');
INSERT INTO `tb_project` (`id`, `name`, `image`, `content`, `standards`, `ranges`, `cate_id`, `cate_name`, `recommend`, `price`, `status`, `note`, `create_time`, `update_time`) VALUES (6, '氩离子', 'http://101.126.90.44/file/project/0d3b889a98e54d758513884511541035.jpg', '<p>氩离子</p>', NULL, NULL, 100000, 'SEM', 0, NULL, 1, '氩离子 ', '2025-05-14 17:39:06', '2025-05-14 17:39:06');
INSERT INTO `tb_project` (`id`, `name`, `image`, `content`, `standards`, `ranges`, `cate_id`, `cate_name`, `recommend`, `price`, `status`, `note`, `create_time`, `update_time`) VALUES (7, '镶嵌', 'http://101.126.90.44/file/project/7cf5a06c134645a4915463e58bde5876.jpg', '<p>镶嵌，</p>', NULL, NULL, 100000, 'SEM', 0, NULL, 1, '镶嵌，', '2025-05-14 17:41:39', '2025-05-14 17:41:39');
INSERT INTO `tb_project` (`id`, `name`, `image`, `content`, `standards`, `ranges`, `cate_id`, `cate_name`, `recommend`, `price`, `status`, `note`, `create_time`, `update_time`) VALUES (8, '镶磨抛', 'http://101.126.90.44/file/project/fe31cde1f8ad49b0b958441f8037e6ff.png', '<p>镶嵌磨抛祛除划痕</p>', NULL, NULL, 100000, 'SEM', 0, NULL, 1, '磨抛', '2025-05-14 17:42:03', '2025-05-26 17:59:21');
INSERT INTO `tb_project` (`id`, `name`, `image`, `content`, `standards`, `ranges`, `cate_id`, `cate_name`, `recommend`, `price`, `status`, `note`, `create_time`, `update_time`) VALUES (9, '电解抛光', 'http://101.126.90.44/file/project/bef30010fabc4ec8954c0af447b1c7a0.jpg', '<p>电解抛光祛除应力</p>', NULL, NULL, 100000, 'SEM', 0, NULL, 1, '点解抛光', '2025-05-14 17:42:25', '2025-05-26 17:59:34');
INSERT INTO `tb_project` (`id`, `name`, `image`, `content`, `standards`, `ranges`, `cate_id`, `cate_name`, `recommend`, `price`, `status`, `note`, `create_time`, `update_time`) VALUES (10, '喷金', 'http://101.126.90.44/file/project/33971e3ec2814eaf830b17fc7b1a79bd.jpg', '<p>喷金</p>', NULL, NULL, 100000, 'SEM', 0, NULL, 1, '喷金', '2025-05-14 17:42:43', '2025-05-14 17:42:43');
INSERT INTO `tb_project` (`id`, `name`, `image`, `content`, `standards`, `ranges`, `cate_id`, `cate_name`, `recommend`, `price`, `status`, `note`, `create_time`, `update_time`) VALUES (11, '拉伸', 'http://101.126.90.44/file/project/09c5ff093d95409da39202e3adb65138.jpg', '<p style=\"text-indent: 0px; text-align: start;\">（1）金属类样品：建议根据国标测试，GB/T&nbsp;228.1-2010；其他尺寸平行段＞20mm，尽量保证长宽比在5：1，厚度大于1mm。</p><p style=\"text-indent: 0px; text-align: start;\">（2）非金属类样品：塑料类可根据国标制样，GB/T&nbsp;1040；其他样品尺寸平行段＞20mm，尽量保证长宽比在5：1，厚度大于1mm。</p>', NULL, NULL, 100001, 'EBSD', 0, NULL, 1, NULL, '2025-05-26 15:17:05', '2025-05-26 15:17:05');
INSERT INTO `tb_project` (`id`, `name`, `image`, `content`, `standards`, `ranges`, `cate_id`, `cate_name`, `recommend`, `price`, `status`, `note`, `create_time`, `update_time`) VALUES (12, '压缩', 'http://101.126.90.44/file/project/e50e602d69b448aa915f4fa8e89e0e2d.jpg', '<p style=\"text-indent: 0px; text-align: start;\">（1）金属类样品：建议根据国标测试，GB/T&nbsp;7314-2017；其他样品尺寸高度在1-50mm，直径＜50mm，样品形状规则，为圆柱体或长方体。</p><p style=\"text-indent: 0px; text-align: start;\">（2）非金属类样品：塑料类根据国标制样，GB/T&nbsp;1041-2008；其他尺寸高度在1-50mm，直径＜50mm，样品形状规整，为圆柱形或长方体。</p>', NULL, NULL, 100001, 'EBSD', 0, NULL, 1, NULL, '2025-05-26 15:32:41', '2025-05-26 15:32:41');
INSERT INTO `tb_project` (`id`, `name`, `image`, `content`, `standards`, `ranges`, `cate_id`, `cate_name`, `recommend`, `price`, `status`, `note`, `create_time`, `update_time`) VALUES (13, '振动抛光', 'http://101.126.90.44/file/project/aa7ecfc874ff4b188ced65e6f2443336.jpg', '<p>振动抛光祛除应力</p>', NULL, NULL, 100000, 'SEM', 0, NULL, 1, '磨抛', '2025-05-26 17:38:03', '2025-05-26 17:59:47');
INSERT INTO `tb_project` (`id`, `name`, `image`, `content`, `standards`, `ranges`, `cate_id`, `cate_name`, `recommend`, `price`, `status`, `note`, `create_time`, `update_time`) VALUES (14, '金相显微镜', 'http://101.126.90.44/file/project/2fe9eac7bfa340e29547f9324eed5ff3.png', '<p>倒置金相显微镜</p>', NULL, NULL, 100004, '其它分类', 0, NULL, 1, NULL, '2025-05-26 17:46:08', '2025-05-26 17:46:08');
COMMIT;

-- ----------------------------
-- Table structure for tb_project_config
-- ----------------------------
DROP TABLE IF EXISTS `tb_project_config`;
CREATE TABLE `tb_project_config` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
  `type` int DEFAULT NULL COMMENT '类型：0da，1是',
  `pid` bigint DEFAULT '0' COMMENT '父id',
  `pids` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '所有上级ID，用逗号分开',
  `sort` int DEFAULT '0' COMMENT '排序',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='预约配置表(暂不用)';

-- ----------------------------
-- Records of tb_project_config
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tb_project_machine
-- ----------------------------
DROP TABLE IF EXISTS `tb_project_machine`;
CREATE TABLE `tb_project_machine` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `project_id` bigint DEFAULT NULL COMMENT '项目id',
  `project_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '项目名称',
  `machine_id` bigint DEFAULT NULL COMMENT '机器id',
  `machine_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '机器名称',
  `price` decimal(10,2) DEFAULT NULL COMMENT '价格',
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='项目机器关系表';

-- ----------------------------
-- Records of tb_project_machine
-- ----------------------------
BEGIN;
INSERT INTO `tb_project_machine` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `price`, `note`, `create_time`, `update_time`) VALUES (111, 1, 'SEM', 1, '电镜1（Nordlys）', 360.00, '', '2025-05-14 17:43:08', '2025-05-26 14:45:44');
INSERT INTO `tb_project_machine` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `price`, `note`, `create_time`, `update_time`) VALUES (112, 2, 'EBSD', 1, '电镜1（Nordlys）', 480.00, '', '2025-05-14 17:43:44', '2025-05-26 14:45:27');
INSERT INTO `tb_project_machine` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `price`, `note`, `create_time`, `update_time`) VALUES (116, 1, 'SEM', 2, '电镜（Symmetry-s3）', 360.00, '不能粉末', '2025-05-14 17:45:27', '2025-05-26 14:45:05');
INSERT INTO `tb_project_machine` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `price`, `note`, `create_time`, `update_time`) VALUES (117, 2, 'EBSD', 2, '电镜（Symmetry-s3）', 660.00, '', '2025-05-14 17:45:38', '2025-05-26 14:44:34');
INSERT INTO `tb_project_machine` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `price`, `note`, `create_time`, `update_time`) VALUES (121, 6, '氩离子', 3, '制样', 600.00, '', '2025-05-14 17:48:04', '2025-05-26 17:52:45');
INSERT INTO `tb_project_machine` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `price`, `note`, `create_time`, `update_time`) VALUES (123, 8, '镶磨抛', 3, '制样', 150.00, '', '2025-05-14 17:48:18', '2025-05-26 17:33:14');
INSERT INTO `tb_project_machine` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `price`, `note`, `create_time`, `update_time`) VALUES (124, 9, '电解抛光', 3, '制样', 200.00, '该价格为最低价格', '2025-05-14 17:48:27', '2025-05-26 17:31:49');
INSERT INTO `tb_project_machine` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `price`, `note`, `create_time`, `update_time`) VALUES (126, 11, '拉伸', 4, '拉伸-压缩', 100.00, '', '2025-05-26 15:33:27', '2025-05-26 15:33:27');
INSERT INTO `tb_project_machine` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `price`, `note`, `create_time`, `update_time`) VALUES (127, 12, '压缩', 4, '拉伸-压缩', 100.00, '', '2025-05-26 15:33:36', '2025-05-26 15:33:36');
INSERT INTO `tb_project_machine` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `price`, `note`, `create_time`, `update_time`) VALUES (128, 13, '振动抛光', 3, '制样', 200.00, '', '2025-05-26 17:38:19', '2025-05-26 17:38:19');
INSERT INTO `tb_project_machine` (`id`, `project_id`, `project_name`, `machine_id`, `machine_name`, `price`, `note`, `create_time`, `update_time`) VALUES (129, 14, '金相显微镜', 3, '制样', 100.00, '自行操作', '2025-05-26 17:46:28', '2025-05-26 17:46:28');
COMMIT;

-- ----------------------------
-- Table structure for tb_project_relation
-- ----------------------------
DROP TABLE IF EXISTS `tb_project_relation`;
CREATE TABLE `tb_project_relation` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `project_id` bigint DEFAULT NULL COMMENT '项目id',
  `config_id` bigint DEFAULT NULL COMMENT '配置id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='检测关系表（暂不用）';

-- ----------------------------
-- Records of tb_project_relation
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tb_team
-- ----------------------------
DROP TABLE IF EXISTS `tb_team`;
CREATE TABLE `tb_team` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '课题名称',
  `creator_id` bigint DEFAULT NULL COMMENT '创建人id',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
  `status` int DEFAULT '1' COMMENT '状态：0解散，1正常',
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人手机号',
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `authentication` int DEFAULT NULL COMMENT '是否认证，0否，1是',
  `balance` decimal(10,2) DEFAULT '0.00' COMMENT '余额',
  `debt_limit` decimal(10,2) DEFAULT '3000.00' COMMENT '欠款限额',
  `debt_limit_use` decimal(10,2) DEFAULT '0.00' COMMENT '欠款限额已用',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `username` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=200001 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='团队关系表';

-- ----------------------------
-- Records of tb_team
-- ----------------------------
BEGIN;
INSERT INTO `tb_team` (`id`, `name`, `creator_id`, `creator`, `status`, `phone`, `note`, `authentication`, `balance`, `debt_limit`, `debt_limit_use`, `create_time`, `update_time`) VALUES (200000, '河南检测组', 100001, '于俊龙', 1, NULL, '漯河双汇', NULL, 0.04, 3000.00, 960.00, '2025-05-21 20:23:02', '2025-05-21 20:23:02');
COMMIT;

-- ----------------------------
-- Table structure for tb_team_logs
-- ----------------------------
DROP TABLE IF EXISTS `tb_team_logs`;
CREATE TABLE `tb_team_logs` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `type` int DEFAULT NULL COMMENT '日志类型：0添加成员，1删除成员，2权限修改，3修改限额，4充值，5消费',
  `note` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `creator_id` bigint DEFAULT NULL COMMENT '创建人id',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
  `amount` decimal(10,2) DEFAULT NULL COMMENT '金额',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='团队操作日志';

-- ----------------------------
-- Records of tb_team_logs
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tb_team_relation
-- ----------------------------
DROP TABLE IF EXISTS `tb_team_relation`;
CREATE TABLE `tb_team_relation` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `team_id` bigint DEFAULT NULL COMMENT '课题id',
  `team_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '课题名称',
  `user_id` bigint DEFAULT NULL COMMENT '用户id',
  `username` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户名称',
  `is_creator` int DEFAULT '0' COMMENT '是否创建者：0否，1是',
  `approve` int DEFAULT '0' COMMENT '是否有审核：0无，1有',
  `status` int DEFAULT '0' COMMENT '状态：0申请，1通过',
  `view_power` int DEFAULT NULL COMMENT '查看权限，0自己，1所有',
  `amount_power` int DEFAULT NULL COMMENT '使用金额权限：0无，1固定，2全部',
  `debt_limit` decimal(10,2) DEFAULT '3000.00' COMMENT '欠款限额',
  `debt_limit_use` decimal(10,2) DEFAULT '0.00' COMMENT '欠款限额已用',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='团队管理关系表';

-- ----------------------------
-- Records of tb_team_relation
-- ----------------------------
BEGIN;
INSERT INTO `tb_team_relation` (`id`, `team_id`, `team_name`, `user_id`, `username`, `is_creator`, `approve`, `status`, `view_power`, `amount_power`, `debt_limit`, `debt_limit_use`, `create_time`, `update_time`) VALUES (34, 200000, '河南检测组', 100001, '于俊龙', 1, 1, 1, 1, 2, 3000.00, 960.00, '2025-05-21 20:23:02', '2025-05-21 20:23:02');
INSERT INTO `tb_team_relation` (`id`, `team_id`, `team_name`, `user_id`, `username`, `is_creator`, `approve`, `status`, `view_power`, `amount_power`, `debt_limit`, `debt_limit_use`, `create_time`, `update_time`) VALUES (35, 200000, '河南检测组', 100000, '李东', 0, 1, 0, 0, 1, 1000.00, 0.01, '2025-05-21 20:23:21', '2025-05-21 20:23:21');
INSERT INTO `tb_team_relation` (`id`, `team_id`, `team_name`, `user_id`, `username`, `is_creator`, `approve`, `status`, `view_power`, `amount_power`, `debt_limit`, `debt_limit_use`, `create_time`, `update_time`) VALUES (38, 200000, '河南检测组', 100002, '于肖涵', 0, 0, 0, 0, 0, 0.00, 0.00, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for tb_token
-- ----------------------------
DROP TABLE IF EXISTS `tb_token`;
CREATE TABLE `tb_token` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '用户ID',
  `token` varchar(100) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'token',
  `expire_date` datetime DEFAULT NULL COMMENT '过期时间',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`),
  UNIQUE KEY `token` (`token`)
) ENGINE=InnoDB AUTO_INCREMENT=1926939883832905730 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户Token';

-- ----------------------------
-- Records of tb_token
-- ----------------------------
BEGIN;
INSERT INTO `tb_token` (`id`, `user_id`, `token`, `expire_date`, `update_date`) VALUES (1920295027329015810, 100001, '7970edd553ed4cadbdd47de7cd5b8ce1', '2025-06-25 16:04:37', '2025-05-26 16:04:37');
INSERT INTO `tb_token` (`id`, `user_id`, `token`, `expire_date`, `update_date`) VALUES (1920295027329015811, 100000, '16280fca91ab4b94933d61fed7ae637b', '2025-06-26 00:49:24', '2025-05-27 00:49:24');
INSERT INTO `tb_token` (`id`, `user_id`, `token`, `expire_date`, `update_date`) VALUES (1923720207216750594, 100002, 'c97740d92acb41ec8fd67c2d741804c5', '2025-06-20 22:07:46', '2025-05-21 22:07:46');
INSERT INTO `tb_token` (`id`, `user_id`, `token`, `expire_date`, `update_date`) VALUES (1924516977580511233, 100003, 'a4df25f45c4246338d1e202996872a69', '2025-06-25 11:36:41', '2025-05-26 11:36:41');
INSERT INTO `tb_token` (`id`, `user_id`, `token`, `expire_date`, `update_date`) VALUES (1925067394802585601, 100004, '05e553b9ab08490d828ccfbf3a689dd8', '2025-06-25 12:04:27', '2025-05-26 12:04:27');
INSERT INTO `tb_token` (`id`, `user_id`, `token`, `expire_date`, `update_date`) VALUES (1926939034377293825, 100005, 'fc2f445f771f4bfabe1dbc4b986e2ba4', '2025-06-25 17:51:10', '2025-05-26 17:51:10');
INSERT INTO `tb_token` (`id`, `user_id`, `token`, `expire_date`, `update_date`) VALUES (1926939883832905729, 100006, '0077377e48104683a332785cd339de09', '2025-06-25 17:54:04', '2025-05-26 17:54:04');
COMMIT;

-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户名',
  `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '手机号',
  `avatar` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '头像',
  `password` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '密码',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `balance` decimal(10,2) DEFAULT '0.00' COMMENT '余额',
  `debt_limit` decimal(10,2) DEFAULT '3000.00' COMMENT '欠款限额',
  `debt_limit_use` decimal(10,2) DEFAULT '0.00' COMMENT '欠款限额已用',
  `score` int DEFAULT NULL COMMENT '积分',
  `coupons` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '优惠券',
  `authentication` int DEFAULT NULL COMMENT '是否认证，0否，1是',
  `type` int DEFAULT '0' COMMENT '用户类型：0正常，1后台添加',
  `openid` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'openid',
  `nikename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '昵称',
  `realname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '姓名',
  `department` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '部门',
  `company` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '公司',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=100007 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户表';

-- ----------------------------
-- Records of tb_user
-- ----------------------------
BEGIN;
INSERT INTO `tb_user` (`id`, `username`, `mobile`, `avatar`, `password`, `create_date`, `balance`, `debt_limit`, `debt_limit_use`, `score`, `coupons`, `authentication`, `type`, `openid`, `nikename`, `realname`, `department`, `company`) VALUES (100000, '李东', '18701538908', 'http://101.126.90.44/file/user/b35528d493a24f018cf27257a4f39f61.jpg', NULL, '2025-05-21 20:20:28', 0.01, 3000.00, 0.01, NULL, NULL, NULL, 0, 'o6SAF7AazblqjHstn0KzfqoW2ojA', NULL, NULL, NULL, NULL);
INSERT INTO `tb_user` (`id`, `username`, `mobile`, `avatar`, `password`, `create_date`, `balance`, `debt_limit`, `debt_limit_use`, `score`, `coupons`, `authentication`, `type`, `openid`, `nikename`, `realname`, `department`, `company`) VALUES (100001, '于俊龙', '18939559563', 'http://101.126.90.44/file/user/b54d76efb51a45a3aa3bc9828a5a4312.jpeg', NULL, '2025-05-21 20:22:05', 0.00, 3000.00, 50.00, NULL, NULL, NULL, 0, 'o6SAF7CJDmMK9GZIZxHgtPLpfua0', NULL, NULL, NULL, NULL);
INSERT INTO `tb_user` (`id`, `username`, `mobile`, `avatar`, `password`, `create_date`, `balance`, `debt_limit`, `debt_limit_use`, `score`, `coupons`, `authentication`, `type`, `openid`, `nikename`, `realname`, `department`, `company`) VALUES (100002, '于肖涵', '18439588609', 'http://101.126.90.44/file/user/612c17aaeadc48ab9ad70386c33d6ebd.jpg', NULL, '2025-05-21 21:31:23', 0.00, 3000.00, 0.00, NULL, NULL, NULL, 0, 'o6SAF7MOTsfSF66yKCyZXVwhzb4A', NULL, NULL, NULL, NULL);
INSERT INTO `tb_user` (`id`, `username`, `mobile`, `avatar`, `password`, `create_date`, `balance`, `debt_limit`, `debt_limit_use`, `score`, `coupons`, `authentication`, `type`, `openid`, `nikename`, `realname`, `department`, `company`) VALUES (100003, 'Solo', '18744008868', 'http://101.126.90.44/file/user/dd12e11059534a2b8aa80bd36511643e.jpeg', NULL, '2025-05-26 11:36:54', 0.00, 3000.00, 720.00, NULL, NULL, NULL, 0, 'o6SAF7LawjrxQguml_SMl7i4W8KE', NULL, NULL, NULL, NULL);
INSERT INTO `tb_user` (`id`, `username`, `mobile`, `avatar`, `password`, `create_date`, `balance`, `debt_limit`, `debt_limit_use`, `score`, `coupons`, `authentication`, `type`, `openid`, `nikename`, `realname`, `department`, `company`) VALUES (100004, '11', '13873064499', 'http://101.126.90.44/file/user/ac32aa90e53e450aacef389a360de87f.jpeg', NULL, '2025-05-26 12:04:47', 0.00, 3000.00, 0.00, NULL, NULL, NULL, 0, 'o6SAF7CbtVM1qEW6J5yNiJkXi_K0', NULL, NULL, NULL, NULL);
INSERT INTO `tb_user` (`id`, `username`, `mobile`, `avatar`, `password`, `create_date`, `balance`, `debt_limit`, `debt_limit_use`, `score`, `coupons`, `authentication`, `type`, `openid`, `nikename`, `realname`, `department`, `company`) VALUES (100005, '今日心琴', '18373062750', 'http://101.126.90.44/file/user/19b7a752869a45828ed23178de2db568.jpeg', NULL, '2025-05-26 17:50:56', 0.00, 3000.00, 0.00, NULL, NULL, NULL, 0, 'o6SAF7NPf1_d1qrRonf7JFg3T7Bg', NULL, NULL, NULL, NULL);
INSERT INTO `tb_user` (`id`, `username`, `mobile`, `avatar`, `password`, `create_date`, `balance`, `debt_limit`, `debt_limit_use`, `score`, `coupons`, `authentication`, `type`, `openid`, `nikename`, `realname`, `department`, `company`) VALUES (100006, '辣黑兔🐰', '18503548288', 'http://101.126.90.44/file/user/eefc419443b54ea0b39bc90c1f685690.jpg', NULL, '2025-05-26 17:54:15', 0.00, 3000.00, 660.00, NULL, NULL, NULL, 0, 'o6SAF7HXWOryuwLZTM2c48ioit7g', NULL, NULL, NULL, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
